Hide table rows except Summary row
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.