In Sample Superstore:
- Put Sum of Sales in the Rows and Count Distinct of Product Name in the Columns.
- Put Product Name to Detail (in Mark section).
- Right click on SUM(Sales), Quick Table Calculation, choosing Running Total.
- Right click on CNTD(Product Name), select Add Table Calculation. Set the Calculation Type on Running Total and Compute Using on Specific Dimension and tick the Product Name. Then tick the Add Secondary calculation. Set the Secondary Calculation Type on Percent of Total and Compute Using on Table (down).
- Right click on the SUM(Sales) in Rows and edit Table Calculation. Set the Calculation Type on Running Total and Compute Using on Specific Dimension and tick the Product Name. Then tick the Add Secondary calculation. Set the Secondary Calculation Type on Percent of Total and Compute Using on Table (down).
- Right click on the Product Name in Marks section and Sort it by Field with Descending Sort Order based on the Sales Filed Name and Aggregation by Sum.
Change the Mark Type from Automatic to Line.
Now, you can see the following beautiful Pareto Chart 🙂
If you want to have two dynamic lines (one vertical and one horizontal for example for 80% and 20%) use the following link:
https://www.thedataschool.com.au/ehsan-forouedinadl/add-dynamic-reference-lines-into-your-charts-example-pareto-chart/
