Forum Discussion

prabhuk's avatar
prabhuk
Helper I
5 years ago
Solved

Matrix table

Hello,

I have 3 tables namely Op Stk, Purchase, Sales and i want to create summary table as below.

When i use matrix table each measurs(Op Stck, Purchase etc..) reflect in seperate column but i need all the materix in one column ("Value").

 

ParticularsValue
Op Stk (From Op Stk table)1000
Purchsaes ( From Purchase table)2000
Sales (From Sales table)2500
Cl Stk (To be calculated from the above)500

 

Need Help
  • MFelix's avatar
    MFelix
    5 years ago

    Hi prabhuk ,

     

    On the matrix options search for the option show on rows this is on the Values part of the options.

2 Replies

  • MFelix's avatar
    MFelix
    Super User
    5 years ago

    Hi prabhuk ,

     

    On the matrix options search for the option show on rows this is on the Values part of the options.

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Community Support
    5 years ago

    Hi prabhuk ,


    According to your request, I simply did the following test: created 3 tables, namely OP, STK, purchase, sales. On this basis, I created a new table structure and data, as shown in the figure. Finally, the ID column is added to rows and the Data column is added to values by matrix visual, and the correct results are obtained. If there are problems, please provide comprehensive table data and information, so that I can do more detailed tests to solve your problems.

     

     

     

     

    Here is the sample pbix file.

     

    Best Regards,
    Henry

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.