I have a pivot table which includes Dollar Share TY & Dollar Share LY columns. These two columns are percentages with value field settings "show value as" % of column total. I want to add a share change column showing the absolute change between the Share TY & Share LY columns. I haven't figured out a calculation or "show value as" that will achieve this.
HELP, PLEASE I've spent a couple of hours digging through online posts & playing around in Excel to no avail.
Thanks in advance for any help you can provide!