Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
i think year=2016 overrides year=.
you can use an Expression like this to ignore all selections
sum({1} if(year=2016, YOURFIELD))
but if i use {1} then it will ignore all the selection, i want it to get affected by other dimensions except year.
Try this
SUM({<YEAR={2015,2016}>}SALES)
This one u did:
Sum({<Year={'2015'}>}Your_field)
Sum({<Year={'2016'}>}Your_field)
Plss try above..I agree with sasi
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