I tried using a calculated field for a pivot table in Google Sheets. For example, there are two pivot table columns, Column1 and Column2, containing numbers.

In the calculated field, I write for example =Column1 Column2. In my case, this is the exact formula:

=ROUNDDOWN((Cheating*25)-('Not Cheating'*100), -3)

The result is correctly displayed. However, when it comes down to the grand totals, it will consider those values as standard values and calculate them the same way instead of displaying the grand totals for the above cells.

The current solution I use is a column outside of the pivot table and just calculate with ARRAYFORMULA. This way, I can tell the formula that it will only calculate for the columns that have values in a third column, so the grand totals are not calculated the same way.

Is there a way I can either use calculated field with proper grand totals (this is what I would prefer), or the ARRAYFORMULA with grand totals at the bottom of the formula calculation?

The sloution

Try

=ROUNDDOWN((Cheating*25)-('Not Cheating'*100), 0)