class Function

[nilesh_gangurde]

Heyy,

            I want to create the date buckets, I have used the class function for that but i am facing some problem. I have explain it in the document attached.

Please help me its urgent..

Thanx in Advance.

Regards,

Nilesh Gangurde

[Jason_Michaelides]

Hi Nilesh,

I don't think I'd use a calculated dimension like you have done.  Instead, just have Customer as the dimension and use a set analysis expression to decide which sales to sum.  I have created 2 new variables (vDateFrom and vDateTo) which give the range of your selected date plus the width.  Then, the expression is:

=Sum({<Date={">$(vDateFrom)"},Date={"<$(vDateTo)"}>} Sales)

See attached - NEW CHART

Hope this helps,

Jason