5 Replies Latest reply: Mar 20, 2014 10:21 AM by Alec Smith

# Set Analysis  - Annual Sum

Hello,

I am trying to sum sales for a year based on the Year list box using the following expression.

sum({\$<Year = {\$(=max(Year))}>} (MainAmount))

The issue is I am losing the annual sales sum when I select a month from the Month list box.  Other than the Year list box, I don't want any other time dimension to effect summing for the year.

Thank you in advance for any help with this issue.

• ###### Re: Set Analysis  - Annual Sum

You ignore Month and other dimensions from the expression.

sum({\$<Month=,Date=,Year = {\$(=max(Year))}>} (MainAmount))

• ###### Re: Set Analysis  - Annual Sum

Try this

sum({<Year = {\$(=max(Year))},MonthField=,Datefield=>} MainAmount)

• ###### Re: Set Analysis  - Annual Sum

SUM({\$<

Year = {'\$(=Max(Year))'},

Field1YouWantToIngore = ,

Field2YouWantToIngore = ,

Field3YouWantToIngore =

>}Amount)

• ###### Re: Set Analysis  - Annual Sum

Thank you all for your help!