Controlling context in set analysis

[#1]

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,

[sunny_talwar · Accepted solution]

Like this?

Sum(TOTAL <Brand>{ <Category = {'Category 1'}>} [Amount])

[#3]

Just like that!

Thank you very much.