Webi report with 2 dimensions and 4 measures
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:
|Sales agent1||Sales revenue||1000||1200||1300||…|
Is it possible to achieve that in webi? Or maybe you have other presentation suggestion.
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.