Forum Discussion

rains_23's avatar
rains_23
Icon for Helper I rankHelper I
11 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
    10 months ago

     

rains_23's avatar
rains_23
Icon for Helper I rankHelper I
10 months ago

It's the same data, except the condition was not added. I have amended the data in the same sheet now.

 

https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdocs.google.com%2Fspreadsheets%2Fd%2F135t1iSDz59lNGk1npZ629_IOkz7ZR1b6%2Fedit%3Fusp%3Ddrive_link%26ouid%3D105535431888411202482%26rtpof%3Dtrue%26sd%3Dtrue&data=05%7C02%7Crenu.agrawal-dongre%40comreg.ie%7Cf63f38333b294fe4cfc808de04b413c3%7C7e3063639dee4b8d8a6b4fee706b37fa%7C0%7C0%7C638953368677174665%7CUnknown%7CTWFpbGZsb3d8eyJFbXB0eU1hcGkiOnRydWUsIlYiOiIwLjAuMDAwMCIsIlAiOiJXaW4zMiIsIkFOIjoiTWFpbCIsIldUIjoyfQ%3D%3D%7C0%7C%7C%7C&sdata=CeZjmCSuxZG2QuVZTCUVMQnzHkstKoEpQd0T6YkM%2Fks%3D&reserved=0

 

lbendlin 

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
10 months ago

 

  • rains_23's avatar
    rains_23
    Icon for Helper I rankHelper I
    10 months ago

    Thank you, it worked.

     

    I accepted it as a solution.

     

    Thanks a million.

     

    Rains