Multiple Filter in Dashboard 4.0

[Former Member]

Hello Expert,

I am new to Dashboard 4.0 and stuck at simple dashboard. The scenario is like this

Suppose i have a data set which is something like this

                           JAN FEB    MAR    APR
1000    Actual
1000    Budget
1000    previous
2000    Actual
2000    Budget
2000    previous

Now i create a Line chart with actual budget and previous taking months into x axis...now i want to introduce a filter with company code as well how to do that. 

Is above is the correct way of spreadsheet or some other way. Also when i have more than one actual(In above case with 2013 and 2012) and selecting spreadsheet with above values, actual budget and previous is coming two time. How to correct that

[former_member195290 · Accepted solution]

Hi Nishant,

Use the FIltered Rows in combo box component to filter the data according to Company code and than map the filtered data to the line chart.

Check this document by Sara G , explained clearly.

http://scn.sap.com/docs/DOC-44056

Regards,

Javed

[Former Member · Accepted solution]

Hi Javed,

Thanks for the reply,

I tried to used combo box and getting the filter ...but then how to map the resultant data with my combo box....as my data sheet will filter 1000 and 2000...but still actual budget and previous will appear twice in my line chart because aggregation is not happening...

Regards

Nishant

[former_member195290 · Accepted solution]

Hi Nishant,

I have tried your scenario,please find attached XLF.

Note: Download the file and change the file extension from txt to xlf.

Regards,

Javed

MultipleFilter.txt.zip

[Former Member · Accepted solution]

Thanks a lot Javed.

Regards

Nishant