Forum Discussion

hani1711's avatar
hani1711
Regular Visitor
1 year ago

Distinct Count Based on Week Number Before Selected Week

Hello,  I have table consist of CustomerID, TransactionDate, WeekofYear. I want to DISTINCTCOUNT the customer based on 6 weeks before current week and display it in column chart. So if the column ch...
Need Help
hani1711's avatar
hani1711
Regular Visitor
1 year ago

because 004 isn't in week 47, the customer should be in the week 47 first before checking last 6 week

ryan_mayu's avatar
ryan_mayu
Super User
1 year ago

for the middle pivot table. if not in week 47, then even it exists in last 6 weeks, we don't want that. Why we need to check last 6 weeks?