Don't want every chart to change.

[kstroupe]

Hello Everyone.  I need a little help with dashboard design.  Here is the issue..  In my dashboard I have a Current stock element which should change value when I use a filter based on a manager.  Currently this is changing when I change the financial year and financial month but I don't want it to.

[Anonymous]

Kim,

See if this expression gives you what you need:

Sum({<MONTH=,YEAR=>} STOCK_VALUE)

[wallinpeter · Accepted solution]

You need to do set statement in expression....

=Sum({$<YEAR=,MONTH=>}STOCK_VALUE)

[kstroupe]

Worked Perfectly