Forum Discussion
Accumulating subtotals
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
Hi guyclewlowi2,
For your scenario, I think you can keep the original table structure to build a sample file with some fake data , then share it here.
Regards,
Xiaoxin Sheng
Please see below a link to the power BI example table and the example data
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