Skip to Content
Feb 12, 2016 at 10:17 PM

Dynamically change report rows based on a percentage


I'd like to create a report that shows list price, sale price, discount (list price - sale price), and discount percentage (discount/list price), organized by percentage. The source data comes from a fairly detailed and complex universe with sales data. Without modifying the universe, I was hoping there would be a way to force webi to dynamically create rows based on the each percentage level. What I have right now looks something like this:

List Price Sales Price Discount Discount %

500 485 15 3%

But I'd like to have the report look something more like this, where a separate line is shown for each discount:

List Price Sales Price Discount Discount %

200 198 2 1%

100 97 3 3%

200 190 10 5%

Is there any way to get webi to separate the % values into distinct categories (e.g. treat the discount like a dimension instead of an aggregated formula/measure)?