Pivot Table Total

[upaliwije]

I have following pivot table in my Doc.

I want to add Grad total (BRAN+CITY) with Prd_code total also shown under the above table and output report should look llike the one given below

Is this possible if so pls advise me to how to do it. I have attached my sample QV doc

[mayankraoka]

Hi Upali,

Is this you are looking for?

PFA app

Another way is do inline load:

lOAD * INLINE [  

   Dept,Dept1

    BRAN, BRAN,

    CITY, CITY

    BRAN, Total

    CITY, Total

];

With appropriate ID and use Dept1 as field.

Regards,

Mayank

[upaliwije]

Hi Mayank

What I am looking for not Grand Total row but Prd_code wise grand total as shown in my 2nd screen shot

[mayankraoka]

Hi Upali,

Please check updated qvw this is what you want?

'

Regards,

Mayank

[sunny_talwar · Accepted solution]

Another method

Add this to the script

Dim:

LOAD * Inline [

Dim

1

2

];

Dimensions

=Pick(Dim, DEPT, 'Total')

PRE_CODE

RISK_YEAR

Expression

COUNT(DISTINCT POLICY_NO)