Hide table rows except Summary row

[Former Member]

Hi All,

Can some please help me on this..?

For some business requirement, I had to apply some filter in my Web Intelligence report.Then I applied the Sum for one Measure column.

Now the Business wants, they do not want to see the data detail.They just require the Summary.

If I remove the data rows, Due to dynamic aggregation, the summary value shown will be wrong.

The Filter I applied on the table is dynamic.. it says top 5 values by using the rank function.

I have to show just the Sum of the top 5 records.

[Former Member]

Hi.

Other solution is if you are using oracle database you can make the query with the rank function and only retrieve the data than you need....

Good luck!

[former_member212749]

Hi

Change the Font color matching to the background color of the report for the row's that you don't want.Only Sum that would the last colum and will be visible.

Hope this would help you.

Regards

Prashant