5 Months data on each bar with Multiple Dimension.

[swatitomar]

Hi All,

I am Trying to do cumulation with Multiple Dimension which show 5months data on each bar...

I tried ,but stuck on one point ..

So for referance i am attaching the qvw here..

In Qvw you can see ,I select one Brand i.e. 'A' ..

Please check Double Dimension Chart First bar : It should show the data of 5 months from Aug12-Jan13

but it is showing data from May12-Jan13, which is wrong....As Sep12,Oct,12,Nov12,Dec12 has no data....

I want that each bar should show 5 months data only,in case some months has its data or not..

Thanks in Advance..

Swati

[sunny_talwar]

Is this what you are looking for?

Expression I used for this:

Sum({<Calendar_Master1.MonthYear ={">=$(=Date(addmonths(Max(Calendar_Master1.MonthYear), -11), 'MMM-YY')) <=$(=Date(addmonths(Max(Calendar_Master1.MonthYear),-0),  'MMM-YY'))"} >}

Aggr(Rangesum(Above(Sum({<Calendar_Master1.MonthYear={">=$(=Date(addmonths(Max(Calendar_Master1.MonthYear), -11), 'MMM-YY')) <=$(=Date(addmonths(Max(Calendar_Master1.MonthYear),-0),  'MMM-YY'))"},Sample.Brand=>}Sample.Sales),0,5)),Sample.Brand,Calendar_Master1.MonthYear))

[swatitomar]

Hello Sunny,

Thanx for your reply ..

Sunny u can also check that now all bar showing 5 months data except 1st bar...

i want that first bar should also show 5 months cummulative value as others..

1st bar showing only Jan13 value rather than Aug12-Jan13..

[#4]

Hi Swati,

Please find the attached file for solution.

I have calculated last 12 months for each month by two methods:

1)  Set Analysis

2) Calculation in Script.

For details plz find attached qvw.