I have a Database with subject and grade like:
| Name | Subject | Grade |
| Peter | Read | 1 |
| Michael | Read | 2 |
| Tom | Speak | 6 |
| Frank | Read | 5 |
| Marc | Speak | 4 |
| Tim | Read | 3 |
I want to create a Table with a mini-diagram looking like the following table:
| Read | ▄ ▄ ▄ _ ▄ _ |
| Speak | _ _ _ ▄ _ ▄ |
Therefore I take the Grade as the Dimension and the result ist =count(Grade). This leads to the following result:
The problem is that the dimensions within each row is reduced to those, which are available.
So my question is:
Is there a possibility to extend the dimension (e. g. TOTAL Grade)? (TOTAL does not work for dimensions).
Kind regards, Michael
