Hello,
I want to count sales numbers with line chart by monthly and store, as following requirements.
<Requirements>
1. If the count is brank (there is no sales data in the month.), I want to show it as 0.
2. On the other hand, if Sales_Month (sales month of each sales data) is before Opening_Date (opening date of each store), I don't want to show it (deal as brank).
About Req 1, I have tryed to useing ISBLANK. However, the count was not shown (brank).
About Req 2, I thought it is better that compare each month with Opening_Data by using IF, and if the each month>Opening_Date, count sales data by store, and if the Sales_Month <Opening_Date, it is dealed as brank.
However, the Sales_Month and Opening_Date could not be select in IF and could not be compared.
I'm using this bpix : SampleBI.bpix
Any help would be greatly appriciated.
Thank you for looking.
Iwamoto
