Sub totals simple table and pivot table

[#1]

Hi,

How can I put Sub Totals after Each Month (column) and each Year (column) in simple table and Pivot table :

Thx in advance

[marcus_sommer]

Within a pivot-table you could simply enable sub-totals for each dimensions which you want within the object properties in tab presentation (top left). By a straight-table or a tablebox you need to create these additionally total-rows within the script and calculate the totals within the script (necessary by the tablebox) or within the gui with additionally conditions in the expressions. I suggest you choosed the pivot-table than the other objects haven't any real added value for the efforts they need for this.

- Marcus

[alibd225 · Accepted solution]

Dear Louis,

just check mark in show partial sums.

[svenkita]

Attaching a sample for doing totals in a pivot table

if you right click on the pivot table and select properties

Presentation Tab

Select the dimension of year and month in the "Dimension and expressions"

and select show partial sum

hope this helps