Forum Discussion
Financial Reporting
Hi Team,
I'm creating a power bi report in a matrix format and I'd want the matrix to like the table on the right.
Basically, there are 4 codes namely: A,B,C,D and each code has 4 categories (1,2,3,4). In the end result table, I'd like to know how we can show the sum of certain Categories and also include the sum of certain Codes.
Thanks
2 Replies
ankush-vem , You need to create Groups to get revenue , COGS etc.
You can try to use isinscope to make all details in the category as blank and try to hide them.
refer if needed
https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/
https://community.powerbi.com/t5/Desktop/Traditional-Financial-Statements/td-p/7223
Hi amitchandak , Can I get further help with the DAX formula and how to go about this?
