Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
In Pivot table how to get the row based sub totals.
Hi,
Just add another Expression Which has the expression as Column(1)+Column(2).... .This will give you the Sum of that Row.
Thanks Syed,
In the pivot table you have the option of converting the dimension(Rows ) in to columns. Also we have options to display the subtotals at the top or bottom of the chart. I was looking for the similar option. if the user is trying to change the rows in to columns at runtime he may looking for the totals to be displayed at the each row level .Instead of creating the expression.