Forum Discussion
MiguelSaldana77
Resolver I
Resolver ICalculations at the same table
Hi everybody Do anybody know what I need to do calculations at the same table like this?
d_gosbell
Super User
Super UserIf 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
MiguelSaldana77Thanks d_gosbell but the real problem is to make the last calculation (see image )
- d_gosbell
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/)