Forum Discussion

bdehning's avatar
bdehning
Icon for Post Prodigy rankPost Prodigy
2 years ago

Showing Top 3 Counts in Matrix Table

I have this Matrix table that uses Body Grouping for Rows, Cause Grouping for Columns and Values is Total Count.  What do I need to create to show only the Top 3 Causes For the Top 3 Body Grouping.  ...
Need Help
bdehning's avatar
bdehning
Icon for Post Prodigy rankPost Prodigy
2 years ago

Should have stated Top 3. Sorry

  • bdehning's avatar
    bdehning
    Icon for Post Prodigy rankPost Prodigy
    2 years ago

    I got closer by using Body Grouping as Filter and using Top 3 by Total Count.  Now I need a measure to use as a filter to show only the the Top 3 Body Grouping.  

    • bdehning's avatar
      bdehning
      Icon for Post Prodigy rankPost Prodigy
      2 years ago

       

      • bdehning's avatar
        bdehning
        Icon for Post Prodigy rankPost Prodigy
        2 years ago

        I am still stuck on this on trying trying not to show columns of Cause that are not included in the Top 3 per Body Grouping.  In this case, I should not see Animal, Burn, Scald, , Exposure, Strike, Step on and Struckby