Uncheck the ‘3D look’ in the display properties. The only thing left is to cumulate the percentages with the runningsum function and we’re almost done:Ĭreate a variable based on the above function and then change the table into a chart with vertical bars and a line: I tried this way in WebI but with no luck I did not manage to get the total sum on the rows.Īfter some fiddling I found the percentage function: If you would do this in excel, then you start with a running sum, and thereafter divide this running sum with the total sum of the revenue. For this example we would like to see the products with the highest revenue. I have a data warehouse based on SAP IDES data and I’m looking at revenue. So here goes my first work related article on my blog. I was asked to create such a chart in WebI and did not find a direct clue on how to do this via google. Wilkinson (2006) devised an algorithm for producing statistically-based acceptance limits (similar to confidence intervals) for each bar in the Pareto chart. In quality control, it often represents the most common sources of defects, the highest occurring type of defect, or the most frequent reasons for customer complaints, and so on. The purpose of the Pareto chart is to highlight the most important among a (typically large) set of factors.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |