Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Goodmorning everyone,
I have the following table :
YEAR | QUAD. | Class | Sez. | ES | Ita | Sto | Geo |
15/15 | I | 1 | A | A | 8 | 8 | 8 |
15/16 | I | 1 | A | A | 7 | 7 | 7 |
15/16 | I | 1 | A | A | 7 | 7 | 7 |
15/16 | I | 1 | A | A | 8 | 8 | 8 |
15/16 | I | 1 | A | A | 9 | 9 | 9 |
15/16 | I | 1 | A | A | 6 | 6 | 6 |
15/16 | I | 1 | A | A | 6 | 6 | 6 |
15/16 | I | 1 | A | A | 7 | 7 | 7 |
15/16 | I | 1 | A | A | 6 | 6 | 6 |
15/16 | I | 1 | A | A | 8 | 8 | 8 |
15/16 | I | 1 | A | A | 7 | 7 | 7 |
how can I get something like :
Disciplina | 10 | 9 | 8 | 7 | 6 | 5 |
Ita | 0 | 1 | 3 | 4 | 3 | 0 |
Sto | 0 | 1 | 3 | 4 | 3 | 0 |
Geo | 0 | 1 | 3 | 4 | 3 | 0 |
thank you
Maybe like this
In your LOAD script:
CROSSTABLE (Disciplina, Vote, 5)
LOAD YEAR, QUAD, Class, [Sez.], ES, Ita, Sto, Geo
FROM YourTable;
LOAD 4+Recno() as Vote
Autogenerate 6;
Then create a pivot table chart, two dimensions, Disciplina and Vote and one expression
=Count(Vote)
Pivot Disciplina to the top.
And disable 'suppress zero values' on presentation tab.
Maybe like this
In your LOAD script:
CROSSTABLE (Disciplina, Vote, 5)
LOAD YEAR, QUAD, Class, [Sez.], ES, Ita, Sto, Geo
FROM YourTable;
LOAD 4+Recno() as Vote
Autogenerate 6;
Then create a pivot table chart, two dimensions, Disciplina and Vote and one expression
=Count(Vote)
Pivot Disciplina to the top.
And disable 'suppress zero values' on presentation tab.