Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is it possible to add a total line independent of dimensions in pivot table? For example, I want to add sum(Value1) to a Total of a column in the pivot table. In the example below, Total is the total line calculated by the pivot table. The "Total vs Variance" is a calculated value of adding a value (not shown) to the negative total (in red).