Skip to main content
Announcements
Global Transformation Awards submissions are open! SUBMIT YOUR STORY
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Sum of sales based on List box selection

Hi folks,

I have following requirement.

i have one list box for Month field.. i have expression for sum(sales) . if no month selected i need to show 12 months total sales. and if i selected april month i need to sum sales upto april..(Sum(sales)for jan feb march april(accumulation))..how can i do this...

Thanks in Advance..

Regards,

Venkat.

11 Replies
kushalthakral
Creator III
Creator III

sum({<Month={'<=$(=Max(Month))'}>} Sales)

Anonymous
Not applicable
Author

Thanks Neetha...for ur explanation....