help with Pivot

[aarohipatel]

Hi,

I am using a pivot in one of my apps. Wanted to know if the following is possible.

I want a new column for  the percentages to be displayed in pivot like in following image.

133/310*100= 42.9%

1/310*100= 0.32%

176/310*100=56.77%

Please advise if this is possible in pivot.(Attached is the qvw and excel with test data)

Thanks in advance

[trdandamudi]

I don't think it is possible with Pivot chart, But it is possible with Straight Table. See the attached file:

Hope this helps...

[sunny_talwar · Accepted solution]

May be like this:

LOAD YEAR,

    QTR,

    STATUS,

    [Total Policies]

FROM

(ooxml, embedded labels, table is Sheet1);

LOAD * Inline [

Dim

1

2

3

];

Pivot Table

Dimension

1) STATUS

2) =Pick(Dim, QTR, 'Total', 'Percentage')

Expressions

Pick(Dim, Sum([Total Policies]), Sum([Total Policies]), Num(Sum([Total Policies])/Sum(TOTAL [Total Policies]), '##.##%'))