Last 3 months calaculation

[Anonymous]

Hi ,

when am using month_year as dimension in the basic view backward stock coverage volume showing correct but  when am using the month name as a dimension in the above chart of basic view  Backward stock coverage volume showing different value,

can you please help me out on this

please find the attached application

Regards,

Devendar

[florentina_doga]

in first chart is month

in second is month year

if in first add year as dimension, value is ok

[florentina_doga]

in the first graph aggregation is done at month without taking into account the year

[Anonymous]

the requirement should be Month as dimension in the first chart and backward stock volume should be match with the second chart

[vishsaggi]

I am not sure how your data model is designed. But i can see that Month Name and Month_Year are coming from qvd inside the calendar table respectively. Just check your Month_Year expression in the edit script of your calendar tab and try adding another column [Month Name] using the same Month_Year expression like

Date(MonthStart(Date),'MMM-YYYY') as Month_Year

Date(MonthStart(Date),'MMM')           as [Month Name].

Comment the Month Name used in the first few lines of the script and use this New MonthName field in your chart and try.

Just my guess the problem is there. If not I am sorry this was just my thought.

Thanks,
V.

[Anonymous]

thank you for replay, i tried this one before but same values are getting nothing is difference