Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
how to do in multiplication division and subraction in pivot table
same column data's
A B
C 5 5
D 8 5
E C/D C/D
if anyone knows please let me know , i tried from past two weeks
so please help me out
Hi,
You would need an if statement for this if this is your needed result:
IF( Dim = 'E'
, Num( Above( Sum( Value ) , 2 ) / Above( Sum( Value ) , 1 ) , '#,#%' )
, Sum( Value )
)
Jordy
Climber
@JordyWegman hi i tried the above one but it does not working so can you please tell about elabrately
where i can put this formula
i put this formula in ROW table but it's invalid so could you please tell about that
Note:
in that value column which field i'm going to put