I want to compare Sum(sales) for selected sub-categories vs Sum(sales) for non-selected sub-categories. Report will have a quick filter on a dimension (in this case sub-category) for selecting values.
There will be a line chart to compare both these amount values. I tried couple of approaches like using parameter (but we can't do multi selection) and also attached file as set based approach but could not achieve desired results.
Please provide your suggestions.