Hi,
I'm trying to create a calculation that based on 2 dimensions and also by the last year of the max selected date
Fields
QuarterDateStart = Starts of the Quarter ( 01/01/2018, 01/04/2018, 01/07/2018, 01/10/2018 etc)
Dim1
Dim2
This is the Calculation that i'm using for the current selection
aggr(sum({1< dim1={'con1'},dim2=$::dim2,QuarterDateStart={"$(=max(QuarterDateStart))"}>} [Measure]),QuarterDateStart)
Example
I selected 2018-Q2 , 2018-Q1
QuarterDateStart = 01/07/2018
The result that I'm looking is (the date is dynamic of course)
aggr(sum({1< dim1={'con1'},dim2=$::dim2,QuarterDateStart={'01/07/2017'}>} [Measure]),QuarterDateStart)
![](/legacyfs/online/emoticons/confused.png)
![](/legacyfs/online/emoticons/confused.png)
![](/legacyfs/online/emoticons/confused.png)
Thanks