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?
Thanks for your assistance!
You can use an 'if' statement to subset to only the rows that have both the YTD values as non-zero. You will have to add this statement in all the 4 columns like I have explained below:
ifelse(YTD_sales <> 0, YTD_sales, null)
ifelse(Last_Year_YTD_sales <> 0, Last_Year_YTD_sales, null)
After doing the above, unclick on "show nulls" so that you see only the rows that have legit values. Hope this helps.
You solve this using Set Analysis and the P "possible" parameter.
You can with this take sales for all stores this year that also has sales previous year, etc.
Syntax can be complex for a beginner, but you will find many examples in this forum. search for "Set Analysis Possible Values".
If you still get nowhere, I can make a small example later this week.