Difference between total of two sub-groups from a same column in a Matrix visualization

[Anonymous]

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. 

[v-lili6-msft · Accepted solution]

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