Forum Discussion
Billed All Months
Hi Team, We have a requirement to check if a Store has Billed Consecutively All months for the last 12 Months. I have data in the below format. If you see the above , i have 2...
andhiii079845
Solution Sage
Solution SageI do not understand the logic:
1) if one store has datas for all month, choose is store.
2) what if both has data for all month?
3) no store has data for all month?
1) is clear, but 2) and 3)?
Please find my answers inline
2) what if both has data for all month? PS: Then Show both the Stores. In brief i want to show Stores that have billed all months.
3) no store has data for all month? PS: then i donot show that Stores in the report.
- andhiii079845
Can you please confirm that only this sales table (no relationship to other tables) is involved with the three columns (YYYMMDD, StoreCode and Billno.) ? I will try to build a PBI for you.