Set analysis on qtr-yr

[Anonymous]

Hello,

I have data from 2015 Q3 to 2017 Q2

I am trying to show a line chart that would show the sum of the years data with 2 lines containing the following values:
(Q3-2015---Q2-2016) and (Q3-2016----Q2-2017)

I know you have to use set analysis, but i am having trouble with the syntax.

Please let me know.

Thanks,

Jay

[Digvijay_Singh]

Use measures like this - format your dates as per your data.

Measure-

Sum({<Date={">=$(=Date(MakeDate(2015,6,01),'MM-DD-YYYY'))<=$(=Date(MakeDate(2016,6,30),'MM-DD-YYYY"))}>}Sales)

[zebhashmi]

Sum({$<your_date-Field = {">=start_date<=End_date"}>}Sales)