Hello, I have a table that looks like the following:
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 as IF(Country<>"CC",Element,0) but it doesn't seem to work: it shows the sum of all countries like the IF doesn't exist.
Is there a way of doing it without creating additional columns in the data?
| Country | Element |
| AA | 11 |
| BB | 22 |
| CC | 33 |
I created a calculated field defined as IF(Country<>"CC",Element,0) but it doesn't seem to work: it shows the sum of all countries like the IF doesn't exist.
Is there a way of doing it without creating additional columns in the data?
