Forum Discussion

dthompsonKairos's avatar
1 year ago

Getting a value from a Matrix

I think I know the answer (Nope, you can't), but I am compelled to ask anyway.

 

Is there a way to extract a value from a matrix given a column name and row name?

 

For the purpose of calculations on the subtotals. I figure that I would need to change the Subtotal titles to have unique names.

This matrix does not represent a single table.

Thx

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi dthompsonKairos ,

    Sorry, your request cannot be met at present. This is a field generated by the matrix visual object itself. You can only modify all subtotals to a certain name at the same time, but you cannot modify a subtotal to a unique name.

    I suggest you post your ideas here or search to see if there are others with the same ideas as yours and give them a thumbs up. Maybe your ideas will be adopted and realized one day in the future:
    https://ideas.fabric.microsoft.com/ 

    Best Regards,
    Dino Tao