Joining values in dimension

[#1]

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

[Gysbert_Wassenaar]

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