How to show last 6 month with Month-Year as a dimension

[kavita25]

Hi,

I want to show last 6 month of Order Date with month-year as a dimension of Sale Date.

I am able to achieve last 6 month of order date on the basis of selection of Month Year(Sale Date).

For e.g If i select Jun-2015, it shows Last 6 Months of Order Date i.e Jun Jul Aug Sep Oct Nov Dec.

Please help me with this issue.

Its Urgent.

Regards,

Kavita

[Anonymous]

may be like this?

Dimension: monthName(OrderDate)

Expression:  Sum({<OderDate, OderDate={'>=$(=Date(max(OrderDate)-180,'OrderDateFormat'))<=$(=date(max(OrderDate),'OrderDateFormat'))'} >} Sales)

[kavita25]

I want last 6 month on the basis of Month Year of Sale Date.

[sasikanth]

HI,

try this

Dimension : Month_Year

sum({<Month_Year={">$(=Date(AddMonths(max(Month_Year) ,-6),'YYYYMM'))<=$(=Date(AddMonths(max(Month_Year) ,0),'YYYYMM'))"},Year=,Month=>}Sales)

[kavita25]

I have two date fields, on the basis of Sale date Month year, it should show last 6 month on the basis of Order Date Month Year.

[sasikanth]

Please do share your app or sample data

[kavita25]

PFA where salesposted date is for Jun, so I want data for Jun,Jul,Aug Sep, Oct Nov & Dec of Travel Date.

[kavita25]

Please Help me with this issue...

[sasikanth]

HI,

try to post the Full data , attachment have only two Dates nothing more than that

Please come up with sample application

[kavita25]

I want on the basis of two dates only and count of 3rd coilumn.

Sales date is for Jun-2015 and Next 3 months should be for Jun-2015 to Dec 2015.(Travel Date)