Forum Discussion

guyclewlowi2's avatar
guyclewlowi2
Frequent Visitor
9 years ago
Solved

Accumulating subtotals

Is it possible to add accumulating sub totals into a matrix table in Power BI. So for example Income, cost of sales and then a subtotal called gross profit, then overheads and another subtotal called...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi guyclewlowi2,

     

    >>So for example Income, cost of sales and then a subtotal called gross profit, then overheads and another subtotal called net profit. The net profit would be a calculation of gross profit + overheads and not just total the overheads

    Power bi not support these feature, you should write measures to calculate for these calculations and drag them to values field.

     

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Can you provide some sample data so that we can have better understanding towards result formulation?

 

Regards,

Hemant

  • guyclewlowi2's avatar
    guyclewlowi2
    Frequent Visitor
    9 years ago

    Hi Hemant,

     

    Thanks for replying to the post, because its company financial data I cant share but it is typical nominal ledger transactions (in this case from SAGE 50)

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      You can obviously mask the data & provide us for our understanding towards its structure & the result you want to replicate out of it.

      Regards

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Or use https://www.mockaroo.com/ to make some fake sample data that has the same structure.