please help..with missing record dates.

[#1]

I want missing record dates with a null value.when there is no datas with specific date i want that sum(ordersalesamount) with null value

Please find the attachment file

in that

in this I want null value dates ( 20-4-2005,....etc.)and so on what i want do in a mastercalender..

[luciancotea]

Remove the Category dim. See attach.

[sujeetsingh]

See this sample i have done it for you on one table.

[#4]

Hai Thankyou

what we want to do with a category dimen.

[#5]

Thankyou

I want sorted dates ..?

But if i start its not exhbiting properly

[sujeetsingh]

You can sort it as you want it .Are you unable to do it