BusinessObjects Board

Filters in Dashboard

other Xcelsius - Crystal Dashboard Design
#1

Hi All,

I am new to Excelsius don’t know depth knowledge. I have some Materials data in Excel . The columns in Excel are Country Year Month Plant MaterialGroup Material ActualYield StandardYield respectively. I want to present this data in Dashboard.

Example Data in Excel:

Country Year Month Plant MaterialGroup Material ActualYield StandardYield

USA 2013 1 3000 1116 1039051 90 100

USA 2013 1 3000 1116 1039248 92 90

USA 2013 2 3002 1126 1039051 80 50

USA 2013 2 3002 1126 1039311 10 10

Europe 2013 1 2500 1191 1081794 90 80

Europe 2013 1 2000 1116 1039248 30 50

CA 2013 1 3400 1191 1081794 90 80

CA 2013 2 3400 1106 1043500 85 80

How to apply cascading filter on Country-Plant-Materialgroup-Material.

When i select country as CA only 3400 plant need to be populate in Plant combo box similarly when i select plant as 3400 only 1191 and 1106 need to populate in Material group combo box same for material combo box also.

Can any one please suggest how to do this in Crystal dashboard.

Appreciate for the guidelines.

Thanks&Regards,

siva4bw (BOB member since 2013-11-15)

#2

Use combo box component & select Insertion type(General tab) as “Filtered rows”.

kraf (BOB member since 2013-06-25)

#3

Thanks kraf…can you please tell how to create Analytic grid based on these filters.

siva4bw (BOB member since 2013-11-15)