Forum Discussion

ringovski's avatar
ringovski
Icon for Helper II rankHelper II
3 years ago
Solved

Matrix 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...
Need Help
  • Mahesh0016's avatar
    Mahesh0016
    3 years ago

    ringovski I hope this helps you. Thank You.
    > 

    compare Total Value =
    CALCULATE([Total Value],ALL('Table A'))

     

Mahesh0016's avatar
Mahesh0016
Icon for Super User rankSuper User
3 years ago

ringovski Please can you share your Expected results in a table? Thank You. 

ringovski's avatar
ringovski
Icon for Helper II rankHelper II
3 years ago

Hopefully 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  
         country1001328967 12888454 
         country10184353905 27880729 
         country10241839  230237
         Total85724711 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)

                                ))