Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
May be like this
Sum({<CLASSIFIY = {'Customer', 'Partner'}>+<CLASSIFIY = {'ISV'}, FiscalYearQuarter = {"2014*", "2015*"}>} METRIC_VALUE)
May be like this
Sum({<CLASSIFIY = {'Customer', 'Partner'}>+<CLASSIFIY = {'ISV'}, FiscalYearQuarter = {"2014*", "2015*"}>} METRIC_VALUE)