pivot_expression

[#1]

Dear all

Seek your expertise. I have a pivot table as below:

Direction	No of Account	Approved Limit (RM'm)	=Aggr(Sum(TMLimit),TM)/ Sum({$<TM-={9700}>} TMLimit)
Non Target	12	477	0.029837476
Selective	42	2,382	0.043216205
Target	8	509	0.038476882

I failed to get the desired result for last column as below

14%

71%

15%

rgrds

[narender123]

Hi,

There is no TM column in your pivot table .1st you have to add TM for aggregation. if you want the result in % then you have to check "Relative" check box(in property of pivot table)  also check  % in number field of property of pivot chart..after this you can get the result in %.

Thanks.

Regards:

Narender

[#3]

1. Direction is the calculated TM dimension:

= if(SCC <> 9700, TM)

2. the result is not accurate even i convert them to %

[amars · Accepted solution]

Hi Alex,

Try out this one for %

Aggr(Sum(TMLimit),TM) / Sum(Total Aggr(Sum(TMLimit),TM))

and convert it into % in the Numbers tab.

Thanks