Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, new to this forum and trying to create a Benchmarking chart.
1. This would be in the form of a Bar Charts.
2. The Industry is selected and the company name is selected.
2. The output will be bar charts of the country Average Sales in a geography and next to it the company performance in that geography.
Please assist and guide in creating qvw's for this.
With regards,
May be using two expressions in a bar chart.
Dimension: Geography
Expressions
1) Country Average Sales -> Avg({1}Aggr(Sum({1}Sales), Company))
2) Company's performance -> Sum(Sales)