Pivot table; show values as percent and total as number

kalabe

New Member
Joined
Dec 4, 2003
Messages
30
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?
 

Dryver14

Well-known Member
Joined
Mar 22, 2010
Messages
2,396
Have you tried dropping the events also into the value section this will give you a count of the events
 

kalabe

New Member
Joined
Dec 4, 2003
Messages
30
Have you tried dropping the events also into the value section this will give you a count of the events
Thanks for your help but that's not the issue. Events is the only entry in the value section and are also the row labels. Days of the week are the column headers.

I want the total of events in the end column as a count but I want the event values under each day to show as a percentage of the total for that row (which is shown in the end column).
 
Last edited:

Forum statistics

Threads
1,081,574
Messages
5,359,707
Members
400,545
Latest member
Damntheman30

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top