aggregate in pivot table

[sutheeshsham]

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

[JordyWegman]

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

[sutheeshsham]

@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