Hi,
I would like to know if is possible to represent each value of the table in a different graphic, for instance:
Material | Aula | Año | Cantidad |
Mesa | Clase 1 | 2019 | 5 |
Sillas | Clase 1 | 2019 | 10 |
Pizarras | Clase 1 | 2019 | 25 |
Mesa | Clase 2 | 2019 | 20 |
Sillas | Clase 2 | 2019 | 100 |
Pizarras | Clase 2 | 2019 | 250 |
Mesa | Clase 1 | 2020 | 1 |
Sillas | Clase 1 | 2020 | 2 |
Pizarras | Clase 1 | 2020 | 3 |
Mesa | Clase 2 | 2020 | 15 |
Sillas | Clase 2 | 2020 | 16 |
Pizarras | Clase 2 | 2020 | 17 |
If I select 2019 and Clase 1 the three KPI graphics must represent an unique value, KPI-1=5, KPI-2=10, KPI-3=25, but if I change the filter to Clase 2 and 2020 the three KPI graphics must represent KPI-1=15, KPI-2=16, KPI-3=17
Best regards,
Juan Muñoz.