Forum Discussion

TCatron18's avatar
TCatron18
Icon for Helper II rankHelper II
1 year ago

Matrix Column Grand Total to be an Average

Hello!   I've looked around the forums and have seen similar questions; however, none have been able to work for what I am wanting to do. I need to have only the total column display averages of th...
Need Help
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi TCatron18,

I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, kindly "Accept  as  Solution" and give it a 'Kudos' so others can find it easily.

Thank you,
Pavan.

TCatron18's avatar
TCatron18
Icon for Helper II rankHelper II
1 year ago

Anonymous Really appreciate your assistance with this. It does provide the average values for only the Total Emp Count value. Though it is not giving the correct value for the Total Sent. It also does not only populate the average at the end of the matrix - it still creates a column for each month. 

I've come to learn that what I am needing is not feasible right now. I have submitted Fabric Idea for this scenario, linked here: https://community.fabric.microsoft.com/t5/Fabric-Ideas/Ability-for-Matrix-Total-to-be-Average-vs-Sum/idi-p/4656184