I am trying to create a pivot table to show marketshare percentages,
essentially I need to show the number of transactions in a pivot table as a
percentage of the subtotal and then the subtotal as a percentage of the
total, is this possible? I can only manage to turn the transactions into a
percentage of the total.