I have data that looks like this:
Month Routine Count STAT Count
October 622 658
November 626 539
December 677 562
I want to make a pivot table where the end result is this:
October November December
Total Studies 1280 1165 1239
STAT Count 658 539 562
Routine Count 622 626 677
Percentage STAT 51% 46% 45%
However I am having trouble figuring out how to do this. About the only thing I know for sure is I want to have the Month column as my Column Label, but I can't figure out how to put the Routine Count and STAT Count, as well as create the "Total Studies" row and the "Percentage STAT" row.
Thanks for any help.
Bookmarks