Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI,
I have a pivot table with one dimension on rows (City) and a Employee dimension on columns. Thus each column in pivot is presenting a seperate employe. I want to add a column at the end, which shows the sum of values in all employees for the city in that row. The values are an expression showing the count of incidents on a specific date.
So basically the ending column shows the sum of all incidents for city that is in that row for all employees. How can I add the total column in the end?
Arif
you need to check show sub total in the presentation tab for your second dimension