Forum Discussion
Difference between total of two sub-groups from a same column in a Matrix visualization
Dear all,
We wanted to have a solution for getting Check value by tallying the Totals of Two sub-groups named Total Assets and Total Liabilities & Equity. Please refer the below screenshot for your understanding.
In our matrix, we are obtaining the Total Assets value and Total Liabilities & Equity values correctly. But, there is another Total that sums all the previous subgroup totals automatically.
Say for instance,
Assets:
Total = 1600
Liabilities & Equity:
Total = 1600
Total = 3200
Instead of 3600, We wanted to have a difference value, 1600-1600 = 0. We are keep trying, but failing to do. Could anyone please help us to achieve the expected results?
Your timely help is much appreciated.
Thanks & Regards,
Praveen.
Hi@ praveenkumarv
After my research ,You can do these follow my steps like below:
Step 1:
when table is Assets then add two columns: Group = "Assets" and Column = Assets[Qty]
when table is Liabilities & Equity then add two columns: Group = " Liabilities & Equity" and Column = -Assets[Qty]
Step 2:
Drag the fileds into matrix visual like below:
Step 3:
Expand all fields at a time
Best Regards,
Lin
1 Reply
v-lili6-msftCommunity Support
Hi@ praveenkumarv
After my research ,You can do these follow my steps like below:
Step 1:
when table is Assets then add two columns: Group = "Assets" and Column = Assets[Qty]
when table is Liabilities & Equity then add two columns: Group = " Liabilities & Equity" and Column = -Assets[Qty]
Step 2:
Drag the fileds into matrix visual like below:
Step 3:
Expand all fields at a time
Best Regards,
Lin