4 Replies Latest reply on Sep 25, 2018 7:41 AM by Scott Anderson

    Distinct count dependant on multiple values in multiple fields

    Scott Anderson

      New to the program, so your patience is appreciated.

       

      I have a data source (that I can't change) that is organized into "modifiers" which describe and attribute and "modifier values" which encode the attribute's value.

       

      How would I show a breakdown of hair colors where young = "yes"?

       

       

      PersonModifierModifier Value
      Obi Wanforceyes
      Obi Wanyoungno
      Obi Wanhairgrey
      Hanforceno
      Hanyoungyes
      Hanhairblack
      Lukeforceyes
      Lukeyoungyes
      Lukehairblonde
      Tarkinforceno
      Tarkinyoungno
      Tarkinhairgrey