how to add up columns in a pivot table arranged in cross tab format..??

[sushil353]

Hi All,

I have created a pivot table and then arranged a expression such that it would look like a cross tab....

Now my problem is i want to add another expression such that it would contain sum of columns...In the table shown below you can understand that i want to add Total QTY in right most to the pivot table

Thanks.

Sushil

[sushil353]

Hi Any body to help???

[#3]

Hi Sushil,

I think you just need to go to the 'Presentation' tab. Then, under 'Dimensions and Expressions', Click on your last field (It should be the one without a label name in your pivot table above) and select 'Show partial sum'.

A right most Total Column should then be created.

Regards.

[sushil353]

Hi Richard,

It is summing up the entire coulmn not the row... and total is shown in the bottom.

[#5]

Didn't u drag that column with values 431,432,433,etc... to be where it is now (horizontal)? It is a dimension, right?

[#6]

Please Sushil, have a look at the following example and let me know  if your pivot table is different from the one I provide here.

Regards.

[#7]

hi sushil could u plz mail me the script of your pivot table...actually i am also having some issues with pivot table..i want to create sub parts in rows with the help of expression like u have done Rss,Rxbr etc...

its urgen tplz