How to build Matrix table with only 3 required fields for each Customer grp, material grp?

[Anmolgan]

I need to build a matrix field that should contains 3 fields in Values section, I want to see Customer group wise region wise and material group wise sales, and for each customer, region and material group I have each separate sum field, how can I use all of that into 1 field as per billed quantity, and 2 more fields, can this be done with any of the methods that we have in our desposal?

[Stachu]

I don't understand what you're trying to achieve, can you elaborate? Do you want to use the Matrix visual? What is your data model? Do you want the columns you mentioned in the rows, columns, or values in the matrix?

Can you add sample tables (in format that can be copied to PowerBI) from your model with anonymised data? Like this (just copy and paste into the post window).

Column1	Column2
A	1
B	2.5