Condition pivot table expression on a dimension

[canmarroig]

Hi, i need to condition a column in a pivot. The yellow one, calculated only if dimension is = DIM 2

How can i do it. I've tried to flag and insert in condition box DIM='DIM 2' but X column doesn't appear

Tks

[Anil_Babu_Samineni]

What formula you want to implement for X?

[canmarroig]

I want to calculate delta%

[Anil_Babu_Samineni]

I will explain you clearly,

1) Create pivot chart

2) Use dimension as A, S.No, ValueList('DIM1','DIM2','DIM3')

3) Create Expressions like

  i) Sum(A)

  ii) Sum(B)

  iii) Sum(DELTA)

And then use finally

If(ValueList('DIM1','DIM2','DIM3') = 'DIM2', Sum(DELTA)) // Then use Relative

Or

If(ValueList('DIM1','DIM2','DIM3') = 'DIM2', (Sum(DELTA)/Count(DELTA)))