farrusete
Member
Hi there,
Its nice to read these forums and find answers to almost everything
. Tried to find something in which my dashboard could be based on with no success so here It is what Im thinking about and ill appreciate if someone could point me in the right direction.
I have 2 sheets:
sheet 1: Data table with:
- sales date
- sales rep
- client
- client group
- product
- amount
sheet 2: the dashboard. I want to put a dropdown list with all unique "Client Groups", two "Year 1" and "Year 2" dropdown lists. When user selects data in those three fields, data table from Sheet1 should be filtered and then displayed below selectors as follows:
[pre]
[/pre]
I can extract that info from Sheet1 by getting just the data that I need based on above dropdown values, but product and clients are ilimited and different in number from one client group to other so... is there some way to display that sortered data table or data from a pivot table in second sheet for me to reference this table and make further calculations / charts in the dashboard?
Thank you so much in advance
Its nice to read these forums and find answers to almost everything
I have 2 sheets:
sheet 1: Data table with:
- sales date
- sales rep
- client
- client group
- product
- amount
sheet 2: the dashboard. I want to put a dropdown list with all unique "Client Groups", two "Year 1" and "Year 2" dropdown lists. When user selects data in those three fields, data table from Sheet1 should be filtered and then displayed below selectors as follows:
[pre]
Code:
- Client1 | Product1 name: (amounts) January Year1 | January Year2 | February Year1 | February Year2 | December Year 2 | Total
- Client1 | Product2 name: (amounts) January Year1 | January Year2 | February Year1 | February Year2 | December Year 2 | Total
- Client1 | Product3 name: (amounts) January Year1 | January Year2 | February Year1 | February Year2 | December Year 2 | Total
- Client1 | Product4 name: (amounts) January Year1 | January Year2 | February Year1 | February Year2 | December Year 2 | Total
....
n times
- Client2 | Product1 name: (amounts) January Year1 | January Year2 | February Year1 | February Year2 | December Year 2 | Total
- Client2 | Product2 name: (amounts) January Year1 | January Year2 | February Year1 | February Year2 | December Year 2 | Total
- Client2 | Product3 name: (amounts) January Year1 | January Year2 | February Year1 | February Year2 | December Year 2 | Total
- Client2 | Product4 name: (amounts) January Year1 | January Year2 | February Year1 | February Year2 | December Year 2 | Total
....
n times
I can extract that info from Sheet1 by getting just the data that I need based on above dropdown values, but product and clients are ilimited and different in number from one client group to other so... is there some way to display that sortered data table or data from a pivot table in second sheet for me to reference this table and make further calculations / charts in the dashboard?
Thank you so much in advance