Joining values in dimension

Thu, 30 Oct 2014 21:41:35 GMT

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

Re: Joining values in dimension

Gysbert_Wassenaar — Fri, 31 Oct 2014 11:00:39 GMT

Use a calculated dimension in your pivot table: =If(match(Dimension,'a','b'),'d',Dimension)