3 Replies Latest reply on Aug 22, 2016 11:53 PM by Yuk Leng Loh

    Filter1 is applied to Sheet1, while Sheet 2 is aggregated by another attribute related to Filter1

    Yuk Leng Loh

      Dear Tableau experts,

      I just started using Tableau and was hoping to get some help on this question. Attaching the sample Tableau workbook...

      Sample data is as follows:

       

      NaneCityStateSavings
      JaneOaklandCA2
      MaryOaklandCA3
      KenSan JoseCA5
      RogerSan JoseCA7
      FrancisBuffaloNY1
      BrendaBuffaloNY2
      KelvinBuffaloNY4
      JosephCortlandNY6
      AliCortlandNY10

       

      In Sheet 1, user is to filter to a City; and then user will see the total savings for that City, which is done in the workbook.

      In Sheet 2, the intention is to show the total savings of the whole State of the City. Eg: If user selected Oakland, Sheet 1 should show total of 5, and Sheet 2 should show total of 17.

      In the actual sheet, there are thousands of cities.

      Appreciate your insights...