1 2 Previous Next 20 Replies Latest reply on Jun 8, 2016 5:02 AM by Bassem Khalil

    Table calculation \ filter problem

    Niko Suomi

      Hello,

       

      I have a situation where I have a table on Tableau that looks like the one here in below .

      We would like to show it differently.

       

      So there is two dimensions ALL and STORE 1.

      The ALL has the ALL-sales value and we have STORE 1, that has only STORE 1 sales.

      And if we create a dashboard where we want to show only STORE 1 values for the area where there is STORE 1 values, and show ALL value to the AREA that does not have STORE 1 value, how it can be done?

       

      I have tried some solutions, but none of them does not work..

      The closest yet, is something like this where I try to create some kinda filter ..

       

      IF [STORE]<>"ALL" THEN { FIXED : MAX(IF [STORE] = "ALL" THEN 0 ELSE 1 END) }

      END

       

       

      COMPANYAREA 1ALL20
      AREA 2ALL20
      STORE 110
      AREA 3ALL20
      AREA 4ALL20
      STORE 1

      10

       

      If any ideas, it would be much appreciated !

       

       

      So this is what I try to achieve:

        

      COMPANYAREA 1ALL20
      AREA 2STORE 110
      AREA 3ALL20
      AREA 4STORE 110

       

       

       

      Cheers,

      Niko

        1 2 Previous Next