• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Filtering table from dropdown

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]
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
[/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
 
Back
Top