Hi Gary @ghartge The assignment worked for me by creating a character parameter that is populated by a drop down list and a calculated measure item that has the measure for only your subgroup. My dataset contains sales data of a retail chain. It has the variables Shop Province and Customer Province and a measure named Total Sales. If I want to imitate your case I want to see the difference in Total sales by Shop Province overall and per selected Customer province. Step 1: Create a Total Sales Customer Province Parameter that is Classified as category and has no default value (or any default value you choose) and allows only 1 value. Step 2: Insert a drop downlist onto your canvas and add Customer Province to the Category role and the parameter of step 1 to the Parameter role. Step 3: Create the measure for your selection: IF ( 'Customer Province'n = 'Total Sales Customer Province'p ) RETURN 'Total Sales'n ELSE 0 And name it Total Sales selection Step 4: Create aggregated measures Total Sales (%) and Total Sales selection (%) by right clicking on Total Sales and then choose New calculation. Choose Percent of Total - Sum Step 5: Create an aggregated measure Difference in Total sales percentage with expression 'Total Sales (%)'n - 'Total Sales selection (%)'n Step 6: Drag a list table onto your canvas and add the variables Shop Province, Total Sales (%), Total Sales selection (%) and Difference in Total sales percentage. My result: If you choose Ethnicity in stead of Shop Province and Population in stead of Total Sales and your selection variable in stead of Customer Province then you are there. Kees Kramer
... View more
