With all the hours of video watching on YouTube, I have not been able to extrapolate a solution to my created Pivot table. I did learn a lot on how to do it using there examples lol. Having said the above, I need some sleep and if anyone can rescue me I would be truly appreciative.
I have a Data table example as follow with Columns as an example: ( have uploaded the spreadsheet with the real info)
Analyst County Compendium WK 06 WK 07 WK 08 WK 09 WK 10
Fred Dade Labs 4,000 7,000 3,000 2,000 5,000
After creating a pivot table, I have it setup as follows:
Analyst and Compendium in the: Row section
Week 7 and Week 6 in the: Value section
Trying to put a comparison with maybe conditional icons show increase , decrease that has the percent difference. AS a bonus, a dynamic one would be awesome but beggars can't be choosers.
Not my job but helping impact patient care if this makes a difference weather you help me or not.
Cordially,
Robert
Bookmarks