Jun 01 2020 09:22 AM
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?