BusinessObjects Board

Fetch Filtered Unique Rows.

other Xcelsius - Crystal Dashboard Design
#1

In my spread sheet I am fetching data from data base.

Now i want to filter those rows and place Unique cells only without any selection criteria.

Means data from 1 column should get filtered and only unique names should get insert on another column without any selection or click.

I tried Index formula but sum how when I run Dashboard it gives #N/A

Can some one suggest.

Thanks in Advance[/u]

Ashurk77 (BOB member since 2013-05-09)

#2

Use the Filtered Rows component. Reduce the # of Columns to 1 in the General Properties.

Also, if you want distinct values, then you should be taking care of this query in the orignal dataset. I can already tell you are not pre-aggregating data.

Cairmor :us: (BOB member since 2008-06-05)