Hello, I have a table that looks like the following:
Country
Element
AA
11
BB
22
CC
33
Now, I want to pivot that table to show me the sum of "Element", BUT Country "CC" has to be excluded from the sum (and shown separately in the same pivot table).
I created a calculated field defined...