Chart Expression

[khasimvali85]

Hi Community,

Hope you are doing well !

I want to discuss about my Query regarding Chart Expression.

I have table fields like Date, Sales,Product.

The Date field contains monthly wise rows not day wise, Sales and Product.(please find attached file).

My Requirement is Create Line chart and its Dimensions should shows like below

Current Month( May-2016) , Previous Month (Apr-2016) and Last Year Current Month (May-2015) and Expression SUM(Sales).

How do i achieve my requirement?

please suggest any one.

Regards,

Khasim.

[Anonymous]

   =sum({<Year={$(max(Year))},Month={$(max(Month))}>} Sales)

   =sum({<Year={$(max(Year))},Month={$(max(Month)-1)}>} Sales)

       =sum({<Year={$(max(Year)-1)},Month={$(max(Month))}>} Sales)