Hello All, hopefully an easy one here. I have a pivot table that, because I need to break out quarterly information for a separate dashboard tab, have broken out by quarter from the original pivot table, that I then recreate second pivot tables for each quarter, so that quarterly charts on a dashboard are updated dynamically (through macros on a dashboard tab).
I am sure there is a better way to create the dashboard altogether however my issue in the current setup is the second pivot table is not reading the percentages appropriately from the formulaic copied table, as I need it to be a simple "as is" read.
I have attached a sample since the above probably makes very little sense, which includes the above descriptions next to each table to clarify. Unfortunately due to file size restrictions, was only able to recreate a small sample sans the dashboard, so please feel free to let me know of any additional questions to help clarify.
Thank you for any assistance, appreciate it. This has been one of those never ending reports that keeps popping up new issues and prolongs the delivery of it!
Thanks.
Sheryl
Bookmarks