Forum Discussion
Solved
Additonal rows by ID with previous value for each day
Hi - I have a dataset that provides historic values for each ID. So, the status for ID 574142 went from 0601 on September 13th to 0803 to September 16th. My goal is to have the count of each status ...
ok try this version
To report on things that are not there you need to use disconnected tables and/or crossjoins
see attached.