Skip to Content

SAP WebIntellingence

Apr 24 at 12:20 PM


avatar image
Former Member


I'm pretty new to this software, and I have a requirement in my WEBI report to calculate the following:

Which Material had the biggest drop in Revenue over a one-year period?

I understand how to show the material and revenue over the years in a visualization graph (Visualisation is required). However, I haven't been able to come up with an answer to demonstrate the biggest drop over a year period.

I have tried to calculate the % of the revenue of each material. But still doesn't work. I might be doing it wrong.

Is there an easier way to find the answer to the above question? I would appreciate the help. Thanks

10 |10000 characters needed characters left characters exceeded

Can you please share the sample data screenshot and what is the formula have you applied?

* Please Login or Register to Answer, Follow or Comment.

1 Answer

Jyothirmayee A Apr 24 at 03:29 PM


Show the percentage of the lowest revenue on the Materials of that year. Bottom 10 or 20 Materials that has lowest revenue compared with Previous year.



10 |10000 characters needed characters left characters exceeded