I have a pivot table with a list of different types of events in the first column (row labels), e.g. boiler repair, floor repair, window repair. The value columns are the days of the week, with the number of each type of event (repair jobs) occurring on each day. I would like to show the grand total in the last column as a number, but the daily figures as percentages of the total of each row. I can only find a way of changing all figures to percent (including the total defaulting to 100%) or to numbers. The only workaround I've found is to repeat the count of event columns but then I end up with twice the number of columns. Ok as a one-off but I need to do this quite often and would like to have a neater template solution. Any advice - please?