I was hoping someome can help me with an issue I have.
I want to get the sum of sales in a pivot table for a period based on the selection made in the field MonthYear and I want to get the sum of sales in the same period in the previous year to compare it with. I all goes well until I make a selection in, for example, a particular brand. If I select MonthYear Jan-2017 till May-2017 but the brand is only first sold this year in Mar-2017, than the result in my pivot table shows the sum of sales of Mar-2017 till May-2017 vs. Mar-2016 till May-2016 (regardless any sales in Jan-2016 or Feb-2016).
Re: Rolling period vs previous year - selection issue
That would have solved the issue if [Brand] was the only field to select, but it is not. It is also possible to select a productgroup, a specific article, a group of customers, unique customer, et cetera. I could just add all these fields to the expression as in: