Hi All,
Hoping someone might be able to help, I'm building a report and think I need to transpose the columns into rows or do some sort of crosstab, please see below for an example of the data I'm getting:
ID
1
2
3
4
5
6
85435
0
7.5
0
7.5
0...
Hi everyone,
I'm trying to create a report which looks at dated records and displays them as ranges then counts the individual ranges and the number of records. Report is grouped by ID. Selection is based on date ranges and record type.
Data example:
ID: Dated:
21 01/12/2023
No record...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.