Forum Discussion
Calculations at the same table
Hi everybody
Do anybody know what I need to do calculations at the same table like this?
4 Replies
Hey,
I'm pretty sure that this site https://www.thebiccountant.com/ will provide you the solution you are looking for.
Regards,
Tom
If header and concept are separate columns in your data model this should work without having to do anything special. You would just put the Header and Concept on the rows of a matrix visual then right-click on a header item and choose "expand entire level".
To get the subtotals at the bottom you just have to go into the Formatting settings for the matrix and change the subtotal position setting to Bottom
Thanks d_gosbell but the real problem is to make the last calculation (see image )
Sorry I did not realise there was any difference between the different dashes in that line. You could implement something like unary operators to solve this (see https://www.sqlbi.com/blog/alberto/2011/03/01/powerpivot-parent-child-and-unary-operators/)
