ExcelDashboardWidgets

[DashboardWidgets]

Hi Adragton

Apologies to take a while to get back to you - we've actually been trying to figure out how to do this and have to confess that we don't think it can be done as when you filter you actually dynamically change the whole setup of the pivot table.

As you are probably aware, it is possible to directly link to values in the pivot table itself by selecting a blank cell and typing "=" followed by a cell in the pivot table it will give you a hard link like..

Code: Select all

=GETPIVOTDATA("Mean Waiting Time Per Consultation (Minutes)",$B$2,"Time Period","April 2012","Health Facility","Health Facility 'A'")

However this isn't particularly helpful as this is a static value that doesn't change with the pivot table filters and you might as well just hard link into the database.

To be honest with you, we think the best solution for making a dashboard that is dynamic and is cable of drilling down into a database is to set up the dashboard with dropdown lists that use the lookup functions (MATCH / INDEX) to look up the values.

We recently posted an example here for a health facility dashboard..

http://www.exceldashboardwidgets.com/ph ... p?f=9&t=14

Sorry that this hasn't fully answered your query. Do you have any simple example data you would be willing to upload so we can get a better sense of what you are trying to do?

Cheers

DashboardWidgets

[DashboardWidgets]

Hi Adragton

I just thought I'd let you know that we recently uploaded another dynamic Manufacturing KPI Dashboard here. http://www.exceldashboardwidgets.com/ph ... p=280#p280

The dashboard uses a dropdown list to drill down into data supplied from a simple database tab.

Good luck with your Excel Dashboard project.

DashboardWidgets