Skip to Content
0
Apr 29, 2014 at 04:57 PM

Percentage Ranking

73 Views

I need to create a WebI report that has just the records with a percentage of a total greater than or equal to a certain threshold.

Here is an similar example from the eFashion universe. So I would like to show States and their Sales revenue where their Sales revenue is greater than 20% of the total, just the highlighted rows. When I put a filter on the Percentage I get the right rows, but the percentage gets recalculated (second block). When I try to do a ranking based on percentage of Sales Revenue the top 20% of the states, not states that are in the top 20% for Sales revenue.

Any suggestions?

Thanks,

Noel

Attachments

pastedImage_2.png (30.6 kB)