A
aablank
I have been trying to get a pivot table to grand total
columns. Even though it is checked in Options, it will
only work if I put a field in the Row section. However
this messes up the formatting with an unnecesary row. Is
there any way to force it (rather than doing it manually
after the fact)? What about adding the Row field and then
hiding it? How do you do that?
columns. Even though it is checked in Options, it will
only work if I put a field in the Row section. However
this messes up the formatting with an unnecesary row. Is
there any way to force it (rather than doing it manually
after the fact)? What about adding the Row field and then
hiding it? How do you do that?