Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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.

v-frfei-msft's avatar
v-frfei-msft
Community Support
6 years ago

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.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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.