Fix a chart to YTD

[chiso_chiso]

Gurus,

Kindly assist, how do i fix a chart to only show YTD values and that it should not change despite other selections i.e. month?

[Michiel_QV_Fan · Accepted solution]

With set analysis you can exclude specific fields from the expression

For instance sum({<Month>}amount) calculates the amount for all other selections but ignores a month selection.

You will see the same also writen as sum({<Month =>}amount). The = isn't necessary, the result is the same.

or

Help text:

sum( {1} Sales )
returns total sales within the application, disregarding the selection but not the dimension. If used in a chart with e.g. Products as dimension, each product will get a different value. 

[chiso_chiso]

Thanks MichielvandeGoor