1 Reply Latest reply on Mar 20, 2016 4:46 PM by Bill Lyons

    Can I force inclusion of one attribute on a filter, plus the viewers selection(s)

    Mike B

      I have a dataset (excel) where the first 2 columns are filters for the third column which contains row labels.

       

         

      MainGroupSubGroupRow Header

      Demographics

      GenderMale
      DemographicsGenderFemale
      DemographicsAge13 to 18
      DemographicsAge19 to 29
      DemographicsAge30 to 49

       

      A viewer can select Demographics from the MainGroup filter, and see all rows grouped by SubGroup, or use a second filter to only show the rows from a specific SubGroup.

       

      I also have a row header called "Total", that I would like to include everywhere. Meaning it is always included regardless of which selection is made in Main Group or SubGroup.

       

      I've got the total row in the same format as the table above, like this:

      MainGroupSubGroupRow Header

      Total

      TotalOverall Total

       

      Is there a way to ALWAYS include MainGroup = Total & SubGroup = Total PLUS whatever a user has selected as a filter from MainGroup and SubGroup?