Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Webi report with 2 dimensions and 4 measures

Hello,

I am new in webi, and I need some help.

I need to design a report with 2 dimensions and 4 measures. It should look something like this:

JanuaryFebruaryMarch
Sales agent1Sales revenue100012001300
Discount90100200
Net Sales91011001100
Gross Marginx%y%z%….

Is it possible to achieve that in webi? Or maybe you have other presentation suggestion.

Lavinia

replied

Zara,

Find below the steps to achieve that

First create a crosstab with Sales Agent on Horizontal axis,Month on Vertical axis and Sales revenue as Body axis.

Then Insert a Column to the right of Sales Agent and name it as "Sales revenue".

Insert a row below the "Sales revenue" and name it as "Discount".Add discount measure to the body

Repeat the same for Net Sales and Gross Margin.

Attached a screenshot for sample

Try and let me know if it helps.

1 View this answer in context
Not what you were looking for? View more on this topic or Ask a question