I have a matrix and using one measure I show 3 entities (Income, Income 2 and Expenses).
Each one of the entities has a list of other sub-entities thus i used a matrix.
What i am trying to do is, for the Grand Total row only to get the sum of the subtotals from Income and Income 2 and subtract the value from Expense Subtotal.
I cannot do it now because all values on this metrics are positive.
Any ideas on how to deal with this without creating negative values for the expenses entity.
Hi @themistoklis ,
Please share some sample data to help us clarify your requirement.
In addition, you can also take a look at following link about measure total calculation: