Hi,
I want to create pivot tables and a dashboard that displays a monthly goal, and which adjusts according to slicers set (month and year).
I have a 'Main data' tab which I records entries weekly.
I have a "Pivot tables' tab that analyses how tasks are progressing over the month.
What I want to be able to do, is set a monthly goal next to the pivot table data, and have values in my dashboard move with the slicers. I want 3 values that move with the slicers:
1) tasks out this month
2) monthly goal (manually set next to the pivot table tab data)
3) a countdown that show have far off the goal I am
I have set up a mock spreadsheet to demonstrate what I am after (as best I can).
I am working off Excel 2010.
Any help would be greatly appreciated!
Bookmarks