Forum Discussion
Sum rows to append to another table
Hi all, Hoping I can get some help with this, fairly new, still learning - hopefully I have given enough detail. I am trying to add a column into my dataset which would sum the entire row as o...
v-easonf-msft
Community Support
Community SupportHi， Anonymous
The general process is as said by Fowmy .
However , I'm still not clear about the structure of your second report.
Can you display your report and result with specific fields and data rather than "0","CATEGORY OF WORK e.g. Processing" ,"Sub category e.g. Preparation".
It will better help us to transform your data.
You may check if this related post help.
https://community.powerbi.com/t5/Desktop/Sum-data-to-new-rows-in-same-table/m-p/885031
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.