Show Data of 6 months back in current month

[mohsinqlik]

Dear All,

I have dimension month,

I need to show data as follow :

Jan 2015 should show data from month Jul 2014, Feb 2015 should data from month Aug 2014.

Similarly Jul 2015 should show data of Jan 2015 and so on.

I have to do it in chart i.e on front end

If anyone have idea how do it in front end using set anaysis then please share.

[sunny_talwar]

Attaching a sample. See if this helps.

Best,

Sunny

[mohsinqlik]

Thanks for your time Sunny ,

I have if condition & have Used Below function to get previous data value

[mohsinqlik]

Hi Sunny,

I wanted to know if there is a way to find YTD of this expression wherein Jul will be considered as my first month

[sunny_talwar]

So from July to July is your year So July 2015 will sum up everything from July 2015 to July 2014??

[mohsinqlik]

For July 2015 it will be count from Jul 2014 till Jan 2015

[sunny_talwar]

Okay, Got it

[sunny_talwar]

Something like this?

If(Year = Max(TOTAL Year), RangeSum(Above(Count(ID), 6,6)))

Attaching the sample with updated expression.

HTH

Best,

Sunny

[mohsinqlik]

Hi Sunindia,

I am back to square one as my requirement is to show month in dimension and the example you gave i am not able to show data in year wise selection. Can you help me out .

Regards,

Mohsin