Hey all, so I have this report which is basically to show how many staff members (count) are working inside a company on different characteristics like gender, city and education level.
------ School 1 ------ ------ School 2 ------ ------ School3 ------
Male ------ Female Male ------ Female Male ------ Female
City 1 box box box box box box
City 2 box box box box box box
City 3 box box box box box box
So as seen above, I have 3 parameters (school, gender, city) which I'm feeding my oracle sql query with, and 1 data field (count) which I get as a result of the feed.
My fast and easy approach/plan was to put the field (count) in all of the boxes and change the parameters dynamically with multivalues etc. based on the boxes column/row values to automatically populate parameters, but there are no documentation on how to do that, or can it even be done?
How can I do that, or is there any other possible approach?