Forum Discussion
Total in Matrix
Hello my friends.
I Try to add the same value from total in new column, in matrix.
I´ve two rows: Region (EEUU, EUROPA), and Cities (CA.LA,MI,MA,PA,PO); two columns (Last Sales, Act Sales).
in the new columns, needs to add Last Sales and Act Sales.
Regards.
HI Anonymous
You need to create two measures similar to this:
General Act = CALCULATE( SUM(Table[Act Sales]), REMOVEFILTERS(Table[Region], Table[Cities])) General Last = CALCULATE( SUM(Table[Last Sales]), REMOVEFILTERS(Table[Region], Table[Cities]))
1 Reply
HI Anonymous
You need to create two measures similar to this:
General Act = CALCULATE( SUM(Table[Act Sales]), REMOVEFILTERS(Table[Region], Table[Cities])) General Last = CALCULATE( SUM(Table[Last Sales]), REMOVEFILTERS(Table[Region], Table[Cities]))