How to add a column in pivot table

[Anonymous]

Hi

Want to add a column (TOTAL) before Region column

for example  want  to add rows(value under north 4, value under east 2 and west 1)so Total should be  7

[avinashelite]

you mean an additional text ? did you tried the calculated dimension or add the text in the label of the region dimension .....

OR

In the presentation tab add the label for partial total  

[devarasu07]

Hi,

First try with "Total on Top" option in pivot table ---> presentation property

another method,

created calculated dimensional measure as like below (update your field accordingly)

aggr(sum(sales),itemNumber,itemColor,Grade)

Note: this cal.dim grant total won't be available.

Thanks,

Deva

[Anonymous]

Partial sum is disabled.

How to use calculated dimension?

[Anonymous]

Hi

This partial sum Option is disables in my chart

and want the following:-

for example

total   east north South  TBC  west

7          2       4        -             -        1

want to add column total in pivot table and total value(2+4+1) ie 7  should be shown under column total that is to be added

[dineshm030]

Hi Saksham,

Could you send your QVW application?