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

[#2]

Can you try something like Expression/ TOTAL Expression and in the Number Tab of the Pivote Table select integer and Show in Percentage(%)

[krishna20]

Hi Ram,

To use total we need to add Sum, Count, Aggr right?

[#4]

Krishna,

Can you send me the sample QVW

[#5]

Hi Krishna,

Select Relative as shown below

[krishna20]

Hi Rupas,

Thanks for reply, Is pivot table is having the relative option?

[#7]

For Pivot..

The expression will be

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

and selected Show in Percent(%) in the number tab

[#8]

relative is not available in pivot or else you can achieve it by writing expression like below,

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

& keep expression default as it is...

[krishna20]

Hi,

This is my Expression. Here TREATY_SEC_SHARE is a field which i need to multiply directly.

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

pls help on this

[#10]

Hi,

Try like below,

=num(((sum(TT_QS_PREM_LC_1)+sum(TT_1S_PREM_LC_1)+sum(TT_2S_PREM_LC_1))*TREATY_SEC_SHARE),'#,##0%')

& keep expression default as it is...

Which field you are using as denominator..