I am using a straight table but I have to have the following columns
column 1: Date
Column 2: Dept1
Column 3: Dept 2
and so on.
I was able to add the date and the departments.
and i added If statement to the expression
I am not able to display the data.
however I added a department list box and if I select one department I get its data and if I select more than once I dont see anything!
So you have one dimension Date and two expressions, right?
try this as expression 1:
and for expression 2:
Does this give you correct data if you don't select anything in field department?
You could also use two dimensions, Date and department and use a pivot table chart, pivoting e.g. department to the top and using sum(Sales) as expression.
Instead of above if() inside the sum, you could also use set analysis, but first try with one of the suggested.