partial sum in pivot table

[tyagishaila]

Hi,

I have a requirement in my pivot table that label of partial sum should be dynamic.

To clear my problem I have attached an image, in this

I need Sub Total BEAUTY

          Sub Total CHILDRENSWEAR and so on...

in place of Sub Total.

Thanks,

Shaila

[robert_mika]

Try this topic:

Custom Labels in Pivot Table

[tyagishaila]

Thanks for your quick response Mika.

But I have huge data Both row wise and column wise.

Use of CustomTotals and Concatenate(CustomeTotals)  will take more efforts.

Dimension1

Dimension2

...

...

...

...

..

DimensionN

same has to repeat for all rows.

is a very lengthy process ...

Regards,

Shaila

[anbu1984]

Re: Showing Dynamic "Total Label"

[Anonymous]

Shaila can you attache your sample application ... so that resolution will be easy to explain.

[tyagishaila]

HI Balkumar,

My application load data from my local machine. how will you open it on your machine.

[Anonymous]

Just load it and attache .. it will work .

[tyagishaila]

I have attached qvw file.

Please find the solution.

Thanks

[Anonymous]

I think this document is corrupted can you upload it again