I want to create report which will show total sum vs sum for selected values.
E.f If I have month from Jan - Dec 2014 and state dimension. I have added sales measure.
Now I want to allow user to select specific months and states and see (actual sales) vs actual sales excluding selected months and states in same graph.
Example - If total sales from Jan 2014 to Dec 2014 across US is 10000000 and user have selected to exclude Ohio and Newyork stated from Jul 2014 to Dec 2014 then what will be total projected ? Formula will be 10000000 - sales of selected months and states.