Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone,
I have a pivot table; columns are : according to year, month; amount and average.
I want "Avg" column only for totals (green box), not for months. How can I do it? (I tried if columnno=0 but it doesnt work).
Thanks
The total function totals what is in the table. If you don't show it in the months, it won't show in the total column.
So this is not possible.