I am working with Retail Sales. I have developed a dashboard where I show Sales, Gross Profit, YTD Sales, Last Year YTD Sales for each store.
I have a requirement where the management requires an apple to apple comparison. What I mean is I would like to compare YTD sales of each store vs Last Year's YTD Sales.
The standad dashboard shows whatever sales data is available inside. For example if a store is closed mid of last year; Its listed in the dashboard. Show 0 for YTD Sales but shows some Sales figures for Last Year YTD. This is not apples vs apples comparison.
By comparing apples to apples means we need to show only those stores which are operational now. We dont need to show those stores closed last year with zero sales, but some figures for YTD Last Year. So for example for all stores the YTD Last Year sales is 1 Million but when we remove those stores closed last year, the figure for YTD Last Year will be less than 1 M. So this is now the realistic picture.
I have a business case for the same apples to apples comparison. We want to show results for properties with scores in both 2016 and 2017. Any property which was only scored in only one of the two years should be excluded from the aggregation.
Has anyone found a good way to filter to show this?