Pareto rule for multiple columns
Hi there, I'm looking for a solution for this case. I have several columns on a single table. So let's called the table "Source Table". All of the columns contain Decimal values. Each column also contains "GlobalTotal" values (as SUM of all items in the column) and some specific data that I need to extract from the expected scenario defined below. The first column contains "Name" values (string). Expected scenario: I need to create a visual (Donut chart) for each column based on these conditions: - the chart will contain only values from a specific column vs the "Name" column for a legend - it will show just the Pareto 80% (deviation +/- 5%) of the "GlobalTotal" based on the HIGHEST values in the column only - The HIGHEST values must contain a filter for "NAME" values, which aren't FILTERED. If there is a way how to do it better by creating a new table from the existing one that will contain just the evaluated values, it is acceptable. Maybe it will save time (because I have several similar tables and +100 columns in total). Here is an example of how to create the New Table from the Source Table: "Total filtered" s the sum of the Highest value in the column based on the 80% Pareto principle explained above. Thank you for a help
