Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
As Marcus Said, More clear Partial Sum of Dimension which you required
This is not what I`m looking for. I want to have a total for the subtotals as a row in my pivot table.
Are you expecting this
Nope , something like this:
Header 1 | Header 2 | Header 3 |
---|---|---|
Text1 | 20 | 50 |
Text2 | 30 | 20 |
Total for columns | 50 | 70 |
Like this
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
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?
No Razva, I did striaght table only. What is the problem to take Straight Table instead of Pivot table.