Restrict a value in dimenion for specific quarters

[ajinkyabhonsle]

Hi Community,

I have the data in the below format in my database:

FiscalYearQuarter	Classification	Value
2014/Q1	Customer	9,798,799
2014/Q2	Partner	7,689,909
2014/Q3	ISV	8,797,997
2014/Q4	Mobile	8,768,768
2015/Q1	Customer	2,392,382
2015/Q2	Partner	1,212,134
2015/Q3	ISV	1,212,989
2015/Q4	Customer	4,365,475
2016/Q1	Partner	4,545,453
2016/Q2	Mobile	3,424,323
2016/Q3	Partner	6,454,322
2016/Q4	ISV	4,564,234

I am using the set analysis in my measures field.
Sum({<CLASSIFIY = {'Customer','ISV', 'Partner'}>}METRIC_VALUE)

What I would like to do is to show the ISV Classification only till quarter 2015/Q4? Any thoughts on handling this?

[sunny_talwar · Accepted solution]

May be like this

Sum({<CLASSIFIY = {'Customer', 'Partner'}>+<CLASSIFIY = {'ISV'}, FiscalYearQuarter = {"2014*", "2015*"}>} METRIC_VALUE)