Hi,
i’ve build a Summary based on the status in a course of some participants.
Any participant depends on an account.
The sql result table looks like this:
PART_ID | STATUS | ACCOUNT
001 | 1 | 401
002 | 2 | 402
003 | 0 | 401
004 | 1 | 401
005 | 5 | 402
The summary is grouped by Status and Account and looks like this:
ACCOUNT / STATUS | 0 | 1 | 2 | 3 | 4 | 5 | TOTAL
401 | 1 | 2 | 0 | 0 | 0 | 0 | 3
402 | 0 | 0 | 1 | 0 | 0 | 1 | 2
TOTAL | 1 | 2 | 1 | 0 | 0 | 1 | 5
I’d like that all the values in the summary were in percentage.
I tried some solution i’ve found reading the forum or the help, but none of them seems to work.
Is possible to do what I want, working with “Events” or I need to get the sums directly with sql?
Excuse me for my bad english, i hope someone will understand what I want to say.
Alfredo