How to summarize a calculated field in a pivot table

Copper Contributor

I have a pivot table.. added a calculated filed with a formula that says if a total in the adjacent column is greater that 0, then I want a "1", otherwise "0".   The formula works, but when I turn on subtotals, I do not get a total for that column.  What I get is the the "1" or "0" based on the formula.


Any idea how to get it to total/subtotal the column?

0 Replies