Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
=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)