Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a requirement where I need the value from one category in a calculation for other categories. The total should be limited to that pivot table column. In the attached file I'm looking for Cat1Value to be 100 for Brand A and 300 for Brand B. I'm using
$(=Sum({ <Category = {'Category 1'}>} [Amount])) but I need to limit it to the current pivot table column. Is there a way to accomplish this? I won't be able to hard code the brand because they'll be different depending on current selections.
Appreciate any help.
Thanks,
Like this?
Sum(TOTAL <Brand>{ <Category = {'Category 1'}>} [Amount])
Just like that!
Thank you very much.