Hello. I have below pivot table based on a database. Would it be possible to add a field in the pivot table based on the if/then condition? for instance, if grand total is >150K for that row, new column will show 1, if >100K but <150K, value shown will be 2, if <100K, value shown will be 3. Pivot table will be changing (rows removed/added) so i would like the values to be updated automatically in the last column of the pvt table, instead of adding this as a separate column outside of the pvt table.
Row Labels Sum Of Amount Calculated field
Apple 250,000 1
Banana 57,000 3
Beans 125,000 2
Orange 5,000 3
Row Labels Sum Of Amount Calculated field
Apple 250,000 1
Banana 57,000 3
Beans 125,000 2
Orange 5,000 3