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)

                                    ))

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

      ringovski I hope this helps you. Thank You.
      > 

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