rush2rajen
Member
Hi Excel Gurus,
I was trying to make a Dashboard but in vain, unable to think out of the box.
There are figures from Apr to Oct with Headings
Vendor ID, Item Id, Dept, Centre & Seven Sheets of Months from Apr to Oct.
What I need is a Dashboard which will show Top 20 Vendor Code of all the months from Apr to Oct, which means in April if there are Top 20 Vendor Code it is not possible that in May that same Top 20 will be there, they may change. No problem in that.
I want to see a Dashboard of Top 20 Vendor Code with Sum of Item ID and Department.
I want to check at one Glance that the top 20 Doctors from Apr to Oct and their Performance on How Much sale the vendor code had given from each dept itemwise.
I don't know whether I had been able to clear your doubts.
Thanks
Raj
I was trying to make a Dashboard but in vain, unable to think out of the box.
There are figures from Apr to Oct with Headings
Vendor ID, Item Id, Dept, Centre & Seven Sheets of Months from Apr to Oct.
What I need is a Dashboard which will show Top 20 Vendor Code of all the months from Apr to Oct, which means in April if there are Top 20 Vendor Code it is not possible that in May that same Top 20 will be there, they may change. No problem in that.
I want to see a Dashboard of Top 20 Vendor Code with Sum of Item ID and Department.
I want to check at one Glance that the top 20 Doctors from Apr to Oct and their Performance on How Much sale the vendor code had given from each dept itemwise.
I don't know whether I had been able to clear your doubts.
Thanks
Raj