For example, I am trying to display orders, backlog, etc in the pivot table which belong to one column. Under that I have to show the current year and prior year count. Now the total formula for Orders is different from the Backlog.
I want to customise the formula only for totals. Let me know in case you need anything else. Thank you