Sum Data from first selected Month to Last Selected Month

[ghassanaldalati]

Dear All.

please help me in this issue.

how can I have the summary of first selected month

                                                  and the last selected month

                                                  and sum form first to last selected month

Example:

Sales For Jan=1000     Feb=2000     Mar=3000     Apr=4000     May=5000   

     when I select from month list Feb+Mar+Apr

I get ( Feb=2000    Apr=4000     from Feb to Apr=9000  )

your coo-operation and support highly appreciated.

Regards

Please see the attachment

[sunny_talwar]

Did you try just using Sum(Sales)? It should sum the sales for the selected months

[ghassanaldalati]

That in case I Select Only One month.

and  if I select Feb+Mar+Apl+May the result will be sum from Feb to May

but what I need is sum for the first selection and sum for the last selection

[sunny_talwar]

May be this

Sum({<Month = {"$(=Max(Month))", "$(=Min(Month))"}>}Sales)

[ghassanaldalati]

Please see the attachment and send me back the right formula in  the same attachment

regards

[sunny_talwar · Accepted solution]

Min

=Sum({<Month = {"$(=MinString(Month(Date#(Month, 'MMM'))))"}>}Sales)

Max

=Sum({<Month = {"$(=MaxString(Month(Date#(Month, 'MMM'))))"}>}Sales)