I'm looking to set up a calculated field in a pivot table that shows the variance to the column total; similar to the show values as % of Column Total option in value field settings, however it has to be a calculated field and is just the straight variance.
I understand that you cannot reference grand totals/subtotals inside calculated fields. Is there a workaround? I have installed PowerPivot thinking I could go that route but haven't found a solution yet.
I understand that you cannot reference grand totals/subtotals inside calculated fields. Is there a workaround? I have installed PowerPivot thinking I could go that route but haven't found a solution yet.
