I am using alternate state to compare 2 different periods. State1 is the first period (year, month and quarter field) and State2 is the second period.
so, first column in the chart shows sales from period 1 and second from period 2. I also want the user to be able to select values from other field like customer, category etc. so, these field are also displayed in multi boxes with no state and the expression look like this:
Period 1: Sum({State1 <Customer=$::Customer, Category=$::Category> Sales)
Period 2: Sum({State2 <Customer=$::Customer, Category=$::Category> Sales)
everything works great, but i have noticed that if a field in the <>brackets has a null value this causes the sales amount not to apear at all.
I have made sure that Customer and Category do not have null values by putting N/A instead. however if I compare 2013 to 2014, for example and the customer did not make any sales in 2013 then there are no lines in the fact and Category would be null, There is no way around this.
Is there anyway to solve the null problem with alternate states?
