Skip to Content
0
Former Member
Apr 15, 2011 at 08:16 AM

How to filter out multiple rows , using multiple selection criteria ?

86 Views

Dear Expert's,

I am stuck with a problem while designing my dasboard.

I have data in the following format.

Year - Quarter - Customer - Division - KF1 - KF2

2005 - Q1 - SAP - Consulting - 10 - 20

2005 - Q2 - IDE - Food - 20 - 10

2005 - Q2 - SAP - Jets - 12 - 11

2006 - Q2 - RAM - Jets - 11 - 11

What i wish to do, is to create radio box(for selection) to choose any Year, Quarter , Customer & Division

eg if the user chooses 2005 , i want to display 3 line entries

2005 - Q1 - SAP - Consulting - 10 - 20

2005 - Q2 - IDE - Food - 20 - 10

2005 - Q2 - SAP - Jets - 12 - 11

if the user further selects quarter - Q2 (without disturbing the selection on for year ) the result should be

2005 - Q2 - IDE - Food - 20 - 10

2005 - Q2 - SAP - Jets - 12 - 11

If the selection from year is removed (still maintaining the selection on quarter Q2 ) the result should show

2005 - Q2 - IDE - Food - 20 - 10

2005 - Q2 - SAP - Jets - 12 - 11

2006 - Q2 - RAM - Jets - 11 - 11

Simply i need to create a filer for all the fields.

The issue that i am facing with filer component is that - 1 - it returns only one desitnation row , 2 - you can only get Key values in result set

Issue with combo box is i cannot select multiple fields (dimensions) using it .

Please suggets .

Thanks in Advance