and([pest]=LOOKUP(“1”,“choose pest”,“match”,“pest”),[crop nr]=lookup(“1”,“choose pest”,“match”,“crop nr”))
This formula is correct according to the expression test.
But when this slice is used to filter data in a chart, the chart returns empty and says “no data available”.
I want to use a detailed view where 2 columns are shown from table 1 to slice table 2 with data to show in a chart.
How to make a working row filter expression for this?
Solved! Go to Solution.
If you check your data source directly, do you see any record where these two evaluations are both correct?
User | Count |
---|---|
38 | |
34 | |
27 | |
23 | |
17 |