How to apply different formula for totals in pivot table

[chandrajakkula]

Dear All,

in Pivot table we added S.No.  , P.S.No. Particular and Region Dimension and written below mentioned expression

Actually We Want two different formula to be applied for Region and for Total separately. but its giving values for only region level and total coming blank please help

		Region-->	South	East	North East	Total
S.No.	P.S.No.	Particular
1	A	Key Operating Parameters:	3688.641028	3172.157214	5122.442666

if(Dimensionality()=4,only(if( EBIDTA_SL_NO=5.1,RP_Per_T_Per_Day)),Only(if( EBIDTA_SL_NO=5.2,RP_Per_T_Per_Day)))

[rubenmarin]

Maybe total has different value for RP_Per_T_Per_Day and is returning null, try using an aggregation funcion (sum, max, avg...):

if(Dimensionality()=4,only(if( EBIDTA_SL_NO=5.1,RP_Per_T_Per_Day)),Avg(if( EBIDTA_SL_NO=5.2,RP_Per_T_Per_Day)))