Hi Friends,
I have a requirement where i need to show 10 KPIs with their values.For ex:
Tried creating Valuelist and created below table.
Most of the expressions are having multi aggregations.
| Metric | Measure |
| KPI1 | 40 |
| KPI2 | 24 |
| KPI3 | 1.5 |
| KPI4 | 99.45 |
| KPI5 | 123 |
| KPI6 | 154.33 |
| KPI7 | 33 |
| KPI8 | 1 |
| KPI9 | 33 |
| KPI10 | 113.09 |
I am able to get the results properly with out any filtering.
My issue comes here: If i filter any of the dimension from the dimensions list.
KPI4 has null value and other has values. But my tables shows entirely null values.
| Metric | Measure |
| KPI1 | - |
| KPI2 | - |
| KPI3 | - |
| KPI4 | - |
| KPI5 | - |
| KPI6 | - |
| KPI7 | - |
| KPI8 | - |
| KPI9 | - |
| KPI10 | - |
Could you please let me know what might be the problem.
