I have 3 list boxes as filter for a chart in my report. All the 3 list boxes comprise of the same field with different expressions.
Foreg: If we have a dimension table comprising of products, regions and customers and we would want to depict sales over a period of time in the chart. We would have 3 list boxes, with the column in the listbox being an expression which states, if(dimension-id = Product, product name) and so on.
In such a scenario, on selecting one of the list boxes, the other 2 would be disabled as the data in the 3 listboxes is from the same column.
Please help me resolve this scenario as we need to have selections made from all the 3 filters. Thank you.
