Show Column If Function

[ecems]

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

[ift_isabelle]

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.