New Row to pivot table

[razvan_brais]

Hy there , is there any way to add at the and of the table a row in wich I calculate totals for each column in pivot table?

Thank you.

[marcus_sommer]

This is an inbuilt feature - go to the tab presentation (top left) and there you could enable for each dimension if totals are displayed or not.

- Marcus

[Anil_Babu_Samineni]

As Marcus Said, More clear Partial Sum of Dimension which you required

[razvan_brais]

This is not what I`m looking for. I want to have a total for the subtotals as a row in my pivot table.

[Anil_Babu_Samineni]

Are you expecting this

[razvan_brais]

Nope , something like this:

Header 1	Header 2	Header 3
Text1	20	50
Text2	30	20
Total for columns	50	70

[Anil_Babu_Samineni]

Like this

[marcus_sommer]

If you have a field [Header 1] and you enabled for them the partial sums like above mentioned you will get exactly such a "Total for columns" row for your expressions.

- Marcus

[razvan_brais]

Marcus , that option I think it`s available only for straight tables . What I have , is a pivot table with a drilldown option. And at the end of the table I would like to sum all values from all rows.

Anil , that is what I need , but is that possible to achive in pivot table?

[Anil_Babu_Samineni]

No Razva, I did striaght table only. What is the problem to take Straight Table instead of Pivot table.