Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAInteresting looking through answers from others. I followed the assumption we want all the date up to today, using the transpose tool to identify earliest and latest date for each client number never crossed my mind!
Quite interesting one.
My Solution.
Went a different route than others. Used a crosstab and transpose combination to find the null values and replace them with zeros.
Been a while since I submitted--I've been using these as a training tool for my team!