Percentage in Pivot Table

[krishna20]

Hi Friends,

How can we show percentage value in pivot table.

I got result for an expression like

Dimension             Expression               %for Expression

A                           121,911,228                  ?

B                           225,221,122                  ?

C                           432,100,101                  ?

D                                132                          ?

E                                   10                         ?

I Have used % in number format,But it shows some exceed value. Please anyone suggest me.

Regards

Krishna

[krishna20]

Hi Harsha,

Thank you for your reply. Please find the attached snapshot which i got after applying as u suggested.

[#3]

Yes,

If your requirement is fulfilled then please close the thread ...

[krishna20]

It's not exactly i want Harsha. We can't show percentages in Lakhs. We need to show percentage for 100.

[#5 · Accepted solution]

Try like below & see,

=num(

((sum(TT_QS_PREM_LC_1)+sum(TT_1S_PREM_LC_1)+sum(TT_2S_PREM_LC_1))*TREATY_SEC_SHARE)

/

((sum(total TT_QS_PREM_LC_1)+

sum(total  TT_1S_PREM_LC_1)+

sum(totalTT_2S_PREM_LC_1))

*

sum(total TREATY_SEC_SHARE))

,'#,##0%')

[krishna20]

Hi Harsha,

Thank you for the support. A little modification in expression brought my answer. 

=num(

((sum(TT_QS_PREM_LC_1)+sum(TT_1S_PREM_LC_1)+sum(TT_2S_PREM_LC_1))*TREATY_SEC_SHARE)

/

((sum(total TT_QS_PREM_LC_1)+

sum(total  TT_1S_PREM_LC_1)+

sum(totalTT_2S_PREM_LC_1))

*

( TREATY_SEC_SHARE))

,'#,##0%')

[#7]

it's pleasure please close thread now..

[#8]

hii

Try this expressions

=num(sum(sales) /total sales),'#,##0%')

or

Sum([Expression ])/Sum(TOTAL [Expression ])