Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
1. Direction is the calculated TM dimension:
= if(SCC <> 9700, TM)
2. the result is not accurate even i convert them to %
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