Set Analysis

[NiTo]

Hi All,

Trying to figure it out but failed. Hoping to get some help here.

Expression that I am using: Sum({<OrderMonthYear>}distinct(ProdId))

OrderMonthYear is a field which gives me Month in format: June-2008, August-2010 etc. ProdId  is another field.

Thing is Bar chart is correct but, I Am getting multiple values of same month in the chart. For eg, 2 bars of Aug 2009 with different value, 3 bars of Sept-2010 with different value.

I want to group all the months from the same year showing me the Sum of Distinct Prodid..

As, it is clear from the chart that multiple bar of the same month are appearing. For eg, Aug 2008, Nov 2008 ,Sep 2008..

Thanks

[anat]

can you share the screenshot of OrderMonthYear data by taking as a filter object,just want to check is any duplicates in that field.

[Or]

That doesn't convert to months, it just formats the date as a month while keeping the underlying value. Instead, try MonthName(OrderDate).

[NiTo]

There is no duplicate. The field OrderMonthYear has many multiple record of same month and that is the reason multiple bar of same month is showing in the chart. 

How to group same month from same year?? So that it will come into a single bar...

[NiTo]

There is one more field called OrderMonth, which gives the details month wise and when I select this as a dimension I am getting the correct chart. The chart shows values by month.

But I want values by month-year. For eg, 250 number of apples were sold in June-2002 and not just June...I hope you get it..

[Or]

Based on your description, you're using a field that has multiple different dates within the same month and you have not transformed it into a month. You've only applied Date() to it, which does not modify the underlying date.

[NiTo]

Hi Guys..

Thanks for you all...

I solved the problem by creating a MASTER CALENDAR