I searched online but I'm not sure if I need to create 3 separate cosstab queries and then somehow join them.
I'm trying to achieve a report that will show a percentage of 3 criteria (checkboxes) based on month.
I'm following some tutorials but I'm unable to add 3 values in one crosstab query.
I'm also not sure how to sum checkboxes as percentages.
Can someone point me to a few good examples?
I apologize for my lack of points but here's my attempt to include some data/pictures:
Here's an example of what I'm trying to acheive:
i.imgur.com/oy5cMbU.png
and here is an example database:
gofile.io/?c=hkr5Op
I'm trying to achieve a report that will show a percentage of 3 criteria (checkboxes) based on month.
I'm following some tutorials but I'm unable to add 3 values in one crosstab query.
I'm also not sure how to sum checkboxes as percentages.
Can someone point me to a few good examples?
I apologize for my lack of points but here's my attempt to include some data/pictures:
Here's an example of what I'm trying to acheive:
i.imgur.com/oy5cMbU.png
and here is an example database:
gofile.io/?c=hkr5Op
Last edited: