Max from possible values (even not selected) - bar chart

[Anonymous]

Hi Guys,

I'm trying to do bar chart which should be no sensible for any selections in listbox Month (January - December , 12 values).

At the beginning this bar chart was working like that:

when you clicked on Month list box for example for June, on chart you saw all months cummulative sums from January to June

I did this among other with expression: Month={"<=$(=Max(Month))"}

Now i would like to have always all months from January to December (all months from Month listobox) on this bar chart which should be not sensible for any selections in Month listbox.

So when you will click on June, on Bar Chart You will see amounts from January to December.

Could you please help me with acheving that?

Thank you in advance for your help,

Jacek Antek

[swuehl · Accepted solution]

Maybe just clear the month field selection?

Sum( {< Month= >} Value)

edit:

Or

Sum( {< Month= {"<=$(=Max({1} Month))"}>} Value)

[hic]

A Set Analysis expression selecting all months should do the trick:

     Sum( Month={"*"} Amount )

HIC

[Anonymous]

Thank You for your swift answer,

This expression:

Sum( {< Month= {"<=$(=Max({1} Month))"}>} Value)

did the good work

Best Regards,

Jacek Antek