0 Replies Latest reply on Dec 7, 2017 11:32 AM by bret van

    How to sum if filter is checked?

    bret van

      I have a data set that contains a thousands of dates, associated days of the week, and an additional variable. Something like below:

      Header 1Header 2Header 3
      DateDOWVariable

      1

      M2
      2T3
      3W4
      4R6
      5F7
      6S34
      7U3
      8M3
      9T123
      10W34563

       

      I'd like to create 3 calculated fields Pk, Sh, Tr.

      Pk = sum([Variable])  but I'd like to filter on DOW.

      I'd like to filter on Day of Week separately for each of the three calculated fields and be able to include all, none, or any combination of weekdays.

      To me it seems I need 3 separate filters for DOW but I can't get the filters to act independently of each other in the calculated fields.

       

      That is, if I deselect, say, M for one calculated field, it affects all of them.

       

      Any idea?

       

      I'm kinda a Tableau noob.

       

      Thanks!