Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
What formula you want to implement for X?
I want to calculate delta%
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)))