Group By Issue......??

[aveeeeeee7en]

Dear Community

The Amount are coming same for April & May Month.

Since I have bifurcated the April & May Month based on Dates.

Kindly see the Attachment.

Regards

Aviral

[Anonymous]

Its better you create a master calendar.That will solve all the issues.

[hic]

Bad data. You have only one value of Combination_Key, and SalesMonth='May' is associated with 30-Apr-14.

HIC

[aveeeeeee7en]

Sir Its not Bad Data.
I have categorized date 30 -April  under  May Month

and  1-28 April under April Month.

[ashfaq_haseeb]

Hi,

may be like his.

Regards

ASHFAQ

[hic]

Then your combination key should reflect this, but it doesn't: It has only one value. It should have two.

HIC