Heating and Other

Maybe you need to create a report that will contain the "N" best / worst item + one item interpreting the sum of those in the "N" best / worst no . Possible steps below. 1 / Determine the order of items to determine the sequence of items according to the indicators you can use the function RANK (), then according to this report Sort the column. 2 / Views "N" best of the rest + Add new column that will contain the calculation of separating " Heating "from other items, such as: CASE WHEN Rank (Prodej. "Yield") <= @ {TopX} {5} THEN Geografie.Stat ELSE 'Other' END Where: RANK (Prodej. "Yield") column is order items TopX @ {} {5} - "TopX" is a Presentation Variable and {5} is the default value (in case you want to let the user dynamically change the value of "N", then it is advisable to use the Presentation Variable - otherwise the value may be constant) 3 / Group podsoučtyAdd new column that will include a calculation to determine podsoučtů (formula is similar to the previous, but instead returns the item name or variable text "Other"): CASE WHEN Rank (Prodej. "Yield") < TopX = @ {} {5} THEN 'Top TopX @ {} {5}' ELSE 'Other' END 4 / Table of values ​​to display when display values, use the pivot table. The lines use computed columns - "Group" (set attribute "Hidden" and calculate the sum) and "Branch". Exclude the original column dimension and the "Order". 5 / Graph to display the values ​​to display values, select as in the case of a table computed column "Branch" (ie not the original "Stat"). Erik Eckhardt.