Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I have a pivot table broken out by month horizontally and by formtype vertically. I have totals across the top for totals by month. How do I also get one column of totals down the side for totals by formtype? It needs to export like that, so the trick of overlapping objects is not applicable this time. Thanks!
(present workaround is a separate little table with just totals by formtype and I copy/paste that column into the exported table with the totals by month. It's only an extra 12 seconds of work but want to make it go away. )
Shouldn't just activating the partial sums for the second dimension work out?
Shouldn't just activating the partial sums for the second dimension work out?
It's a nice facepalm moment, thanks. Didn't click in my brain that the partial sum was associated with the highlighted field and that I could select another field and check the box again. (I rarely use the pivot table object.)