Forum Discussion

rains_23's avatar
rains_23
Helper I
10 months ago
Solved

Totals in Matrix

Hi, I have created a matrix.  The below data gets filtered on a slicer for Date. So for each date, there may be multiple records of O, P, or S for each org name (column1). I want a total as 3, if i...
  • lbendlin's avatar
    lbendlin
    9 months ago

     

rains_23's avatar
rains_23
Helper I
10 months ago

lbendlin  Just tagging you in case you missed my reply. I have uploaded the data in a spreadsheet in google sheets.

  • lbendlin's avatar
    lbendlin
    Super User
    10 months ago

    Here is one example on how to achieve that

     

     

    Maybe rename "Totals" to something else to lessen the user confusion.

     

    • rains_23's avatar
      rains_23
      Helper I
      9 months ago

      @

      lbendlin
      Preview
       

       

      Part of it worked, It is not taking correctly when it has more count in only Type 1, 
       
       
       
       
      • lbendlin's avatar
        lbendlin
        Super User
        9 months ago

        Please post adjusted sample data and indicate expected result.