Dashboard Help - Multiple Drop Down criteria: How to create the best solution:
I am trying to create a dashboard that will output certain data based on a few selections the user of the spreadsheet willl make. I have attached an example of what I am trying to create.
Basically have 2 drop down lists.... wanting each to display totals for there respected selections. Please see attached. I really apprecaite the help on what would be the best formula to use for this.
Valued Forum Contributor
Re: Dashboard Help - Multiple Drop Down criteria: How to create the best solution:
I am hesitant to offer suggestions to a guru (!), but here goes.
I do not understand what you want. Your Output Report replicates the Raw data - so why not just show them the Raw Data?
I attach a solution that will show one column a time, if this is what you want.
I think I am missing something here!
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By anand_erin in forum Excel Programming / VBA / Macros
Last Post: 11-03-2012, 06:35 PM
By jlepard in forum Excel General
Last Post: 07-19-2011, 10:22 PM
By Overlord in forum Excel General
Last Post: 09-18-2009, 07:07 PM
By svineyard in forum Excel Programming / VBA / Macros
Last Post: 07-21-2009, 10:48 AM
Last Post: 09-06-2005, 04:05 AM
Tags for this Thread
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1