I have a made up table that contains information as below.
I’m trying to get a distinct value for each week. i.e. Red|WK1 would be 100.
In all my efforts so far I can only get this to sum up overall.
I would then need it to do the same for each week giving me an overall accurate total as well.
No parts of the table are removable i.e. I can’t take out language.
Hi @StephenM,
Is the ‘Number’ for a week ever going to vary based on your other fields? And in that case would you want to pull the largest or smallest number?
You should be able to achieve this using LAC-W calculations. If the ‘Number’ will always be the same, like your example above; you could try minOver or maxOver.
Let me know if this works for your case or if you have any additional questions!
I didn’t manage to achieve what I was looking for so I ended up changing what I was looking for altogether. I ended up creating a couple new calculated fields and working it out over a percentage rather than giving me the figures.
It’s eventually worked so I’ll take it as a win.