3 Replies Latest reply on Jan 25, 2019 11:48 AM by Mike Arnett

    Create a grouped set based on Yes/No value

    Mike Arnett

      I have a "widget/supply" dataset which has a Yes/No column.  When the value is Yes, it means that the item listed in the Items column is a "widget" and when it is "No" is means that the item listed in the Items column is an associated Supply.

       

      I need to create a report which shows all Widgets and the most commonly distributed Supplies for that Widget grouped underneath that Widget.

       

      How do I create a formula that will show both Widgets and Supplies in the same worksheet?  I can't filter on the Yes/No since it will leave out one or the other.

       

      I want it to look something like this:

       

       

       

       

      WidgetTotal
      Widget x
      Supply 314
      Supply 17
      Supply 82
      Widget y
      Supply 723
      Supply 621
      Supply 98
      Widget z
      Supply 264
      Supply 425