Multiple Criteria Dashboard
- Thread starter id4excel
- Start date
on left hand side the data is manually filled, as those are sales reported to head office.
On right hand side in dashboard, the evaluation of performance will be done on basis of that data.
Example: One of the Dashboard query in I5 is
Top 5 Vendors (based on number of orders)
So the top rankers could be populated in J5 to N5
Hope I am clear this time.
Regards
On right hand side in dashboard, the evaluation of performance will be done on basis of that data.
Example: One of the Dashboard query in I5 is
Top 5 Vendors (based on number of orders)
So the top rankers could be populated in J5 to N5
Hope I am clear this time.
Regards
this is just an example of a large sheet, adding a helper cell is not possible as all department have same type of sheet which regularly copied and pasted in chunks by tech challenged staff.
And any discrepancy in formate or anything will result in huge mess.
Coming back to topic, yes I agree its kind of challenge. Hope some guru will come with a clean solution.
And any discrepancy in formate or anything will result in huge mess.
Coming back to topic, yes I agree its kind of challenge. Hope some guru will come with a clean solution.
NARAYANK991
Excel Ninja
Hi ,
You don't need a helper cell ; what you need is a separate helper worksheet , where all the calculations can be done using helper cells / columns. Without this , deriving all of what you want is probably work for a paid professional.
The reason you have given is not good enough ; every good dashboard is done with the help of helper cells / columns / worksheet ; an interactive dashboard which had thousands of rows of data to deal with , and complicated array formulae to do all the complex calculations in single cells would no longer be interactive ; changing one input data cell would take 10 minutes for the dashboard to update itself.
You need to change your expectations.
The alternative is VBA , but even with VBA , developing all the 20 measures that you want displayed would take a fair amount of code.
Narayan
You don't need a helper cell ; what you need is a separate helper worksheet , where all the calculations can be done using helper cells / columns. Without this , deriving all of what you want is probably work for a paid professional.
The reason you have given is not good enough ; every good dashboard is done with the help of helper cells / columns / worksheet ; an interactive dashboard which had thousands of rows of data to deal with , and complicated array formulae to do all the complex calculations in single cells would no longer be interactive ; changing one input data cell would take 10 minutes for the dashboard to update itself.
You need to change your expectations.
The alternative is VBA , but even with VBA , developing all the 20 measures that you want displayed would take a fair amount of code.
Narayan