issues with current selection

[Anonymous]

I have a table which displays a measure for 2015 and 2016 in two columns

whatever year user selects always 2015 and 2016 data should get displayed in the chart.

i have hardcoded year in the both expression. it should not affected by year selection. Month is my dimention.

I am giving year=2015 inside 2015 expression and year=2016 inside 2016 expression. and year= , but when i select 2016 then data for 2016 shows correct but when i select 2015 2016 becomes zero.

[zhadrakas]

i think year=2016 overrides year=.

you can use an Expression like this to ignore all selections

sum({1} if(year=2016, YOURFIELD))

[Anonymous]

but if i use {1} then it will ignore all the selection, i want it to get affected by other dimensions except year.

[#4]

Try this

SUM({<YEAR={2015,2016}>}SALES)

[sdmech81]

This one u did:

Sum({<Year={'2015'}>}Your_field)

Sum({<Year={'2016'}>}Your_field)

Plss try above..I agree with sasi

[sasikanth]

HI,

By default if you hard code any value of a field then corresponding field related selections will not apply on chart.

Below expressions work,

=Sum({<YEAR={'2015'}>}Sales)

=Sum({<YEAR={'2016'}>}Sales)

Let us know if not