Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi I have a pivot table which has a calculated dimension
Dimension exp 1 exp 2
a 1 2
b 3 4
c 5 7
now the requirement is to combine the 2 fields a and b such that d= a+b and a and b should not be shown
Dimension exp 1 exp 2
d 4 6
c 5 7
also to be noted that this is to be done only on one pivot table rest of the dashboard has it as the original table
any idea how to do this
Use a calculated dimension in your pivot table: =If(match(Dimension,'a','b'),'d',Dimension)