Calculate above data and show the result

[Anonymous]

Hi, i have a pivot table with data like this :

DIM3                                                 A                    B         

DIM1          DATE

Start          26 Oct 2015               10                   20         

Trx             27 Oct 2015                1                    1

the expression on my pivot table is sum(QUANTITY)

my goal is, i want to show a total data from the above data, so the result will be like this:

DIM3                                                 A                    B         

DIM1          DATE

Start          26 Oct 2015               10                   20         

Trx             27 Oct 2015                1                    1

End           28 Oct 2015                11                  21       ------------> I want to show this record.

Do you have any idea ?

Thanks

[marcus_sommer]

If you want to show the total from the column you could enable partial sums - within the tab presentation in top left.

- Marcus

[raman_rastogi]

use partial sum  .

presentation-> partial

[stephenedberkg]

[dmac1971]

Like this maybe?