This content has been marked as final. Show 4 replies
I'm building an expression which should work like this:
I have a data set which has columns for year, for amount and for item. I want to make the chart to show only the items which have their amount of year='2014' higher than year='1995'.
I've tried the following
IF(((year='1995' and "amount")<(year='2014' and "amount")), "item")
which was a long shot and didn't get me far.
Any help with the expression? Thanks.