Forum Discussion
ringovski
Helper II
Helper IIMatrix Table Static Sub Totals
Hi All, I would like to add a row to matrix table thats shows the total Value$ for each column which ignores any product code number filter selected. So you can compare the sum of selected codes num...
ringovski I hope this helps you. Thank You.
>compare Total Value =CALCULATE([Total Value],ALL('Table A'))
ringovskiHelper II
Helper IIHopefully this is enough information and clear. It's the same as Values 'show on rows' option but only for one measures the Total_All_Product_Codes.
Matrix Table, my expected results is the total sum of all product codes in the last row without any filters being applied as 'Total_All_Product_Codes'.
Year Product_Code | 2005 Value$ | 2006 Value$ |
| 121 | ||
| country100 | 1328967 | 12888454 |
| country101 | 84353905 | 27880729 |
| country102 | 41839 | 230237 |
| Total | 85724711 | 40999420 |
| Total_All_Product_Codes | xxxxxxxx | xxxxxxxx |
I have the expected result in a measure however it appears as column and repeats for every row. So obviously not right.
Total_All_Product_Codes = Calculate(SUM(Export_Fact_Codes_All[value$]),
ALL(Dim_Product_Code)
))
Mahesh0016
Super User
Super Userringovski I hope this helps you. Thank You.
>
compare Total Value =
CALCULATE([Total Value],ALL('Table A'))