I‘m facing an issue with the dimension limits in the Pie chart. I would like to show only the Products (sum of sales) where the cumulative percentage is lower than 94% in the pie chart. However, the products with cumulative percentage higher than 94% I would like to put in a new category ‘other‘.
I can do it in a straight table (see picture), I’ve calculated the cumulative percentage (column % Sales cumulative) and also a grouping dimension column (Product group). But how can I do it in a pie chart? Is it posible to make a new grouping dimesion or to use dimension limits without using the same expression that is displayed?
I would like to show second column (‘sum Sales’) in the pie chart, but only for the products where the cumulative percentage is lower than 94% (product 1 up to product 13) and a new category ‘other’ (from product 14 to 21). Like in the column ‘Product group’ in the table.
Thanks for your effort. I still don’t get it. Probably I did not express myself clearly. I have 3 columns: sector (used in filter), Product (product name) and Sales (amount in euro’s). Please see simplified sample of data bellow.
I would like to show Sales per product in a pie-chart, but only for the products where the cumulative % is lower than 94%.
Calculation for Cumulative percentage in straith table is: Aggr(RangeSum(Above(Sum(Sales), 0, RowNo())),Produkt)/sum(TOTAL Sales)
But I don’t know how/where to use it in piechart. How can I tell the pie-chart to show only these products? I've tried it using Dimension Limitation, but I did not succeed.