I am trying to do a tabular report
This report is a scoresheet where the rows will be the measurables and the columns will start with this week and go out 13 weeks.
3 replies
-
I've done something similar, but I use weeks for Rows and measurables for columns.
e.g. Create a new table with 13 records with week numbers. Create calculations for each row you need.
Row 1
let y := Year;
let w := Week;
count(select 'Your Table' where year(Date) = y and week(Date) = w and Type = 1)Row 1
let y := Year;
let w := Week;
count(select 'Your Table' where year(Date) = y and week(Date) = w and Type = 2)and so on...
I hope it helps.
Nick
-
Update...
Create calculations for each column you need.
Column 1
let y := Year;
let w := Week;
count(select 'Your Table' where year(Date) = y and week(Date) = w and Type = 1)Column 2
let y := Year;
let w := Week;
count(select 'Your Table' where year(Date) = y and week(Date) = w and Type = 2)and so on...
-
Thanks for the reply. Much appreciated
Content aside
- 6 yrs agoLast active
- 3Replies
- 1705Views