bobsullivan
New Member
i have a dashboard i have created. Very simalier to the project tracker.
The source data is one tab that is linked to a data list in sharepoint.
i have another tab where i have pulled some data from the sourse tab and then add further data manually. lets call this one data2 tab.
i then have a pivot table in a third tab with ranges difined for each of the columns of data.
then the calculations tab (very similar to the project mgr dashboard) which pulls from the pivot table.
then finally the dashboard tab which has 4 different dropdowns used to filter the data.
the filters exec macros that control the pivot table filters and thus the data in the calcs tab and dashboard.
My question to all is - is there a better way to handle multiple filters on a dashboard?
The source data is one tab that is linked to a data list in sharepoint.
i have another tab where i have pulled some data from the sourse tab and then add further data manually. lets call this one data2 tab.
i then have a pivot table in a third tab with ranges difined for each of the columns of data.
then the calculations tab (very similar to the project mgr dashboard) which pulls from the pivot table.
then finally the dashboard tab which has 4 different dropdowns used to filter the data.
the filters exec macros that control the pivot table filters and thus the data in the calcs tab and dashboard.
My question to all is - is there a better way to handle multiple filters on a dashboard?