Forum Discussion

szona's avatar
szona
Frequent Visitor
8 years ago
Solved

Trouble with KPI Grid by MAQ aggregation

Hello!  I'm struggling a bit with the KPI Grid by MAQ.  I have some hierarchical data with numerator and denominator columns, and a measure calculating percent.  When I put this into the KPI Grid the measure is correct at the row level, however, at parent levels the measure is showing as a sum of all the row measures, rather than calculating the overall percentage for that level.  I think this is an issue with the visual rather than the measure, because the same data placed in a matrix is calculating properly. Any ideas?

 

the data:

 

 

the measure:

 

 

matrix results:

 

KPI grid results:

 

1 Reply