Forum Discussion
Aggregating Calculated Column as Row in Matrix
I have the below matrix. The issue is that the 90 Day column isnt showing the total, its showing only 1 day. Does anyone know if there is a workaround?
The request is to show the 90 Day total, but not to breakout it out by the TS Period columns however it isn't aggregating. I tried making 90 Day a measure, but then it wouldnt let me add it to the Rows area in the visual.
Visual breakout:
Rows-
Proj_ID
Project Name
Title
Employee Name
PYTD Util (calc Column)
90 Days (calc Column)
Columns:
TS Period
Values:
Goal Hours
Actual Hours
Holiday Hours
Variance Actual- Goal
Variance %
I cant share unfortunatly, however I figured this out.
Matrixes rows automatically group like numbers together instead of using the aggregation that was set for that column.
To solve this I had to create a seperate table which grouped the sum total by Employee ID in query editor that I needed and then added that total from query editor into my matrix.
2 Replies
v-frfei-msftCommunity Support
Hi Anonymous ,
Kindly share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.
I cant share unfortunatly, however I figured this out.
Matrixes rows automatically group like numbers together instead of using the aggregation that was set for that column.
To solve this I had to create a seperate table which grouped the sum total by Employee ID in query editor that I needed and then added that total from query editor into my matrix.