3 Replies Latest reply on Apr 5, 2016 6:36 PM by Shinichiro Murakami

    filtering without affecting the results (% of total )

    gogineni vishal

      Hi All .

       

      I have the following problem.

       

      I would want tableau to filter the view without affecting the percentage of table calculation in the graph .

       

      2016-04-06 10_13_25-Tableau - Problem with filering.png

       

      So in the above view : Calculation1 is a calculated field using the following forumla:

       

      IF [Category]="Furniture" OR [Sub-Category]= "Tables" THEN "Furniture/Tables"

      ELSEIF [Category]="Technology" OR  [Sub-Category]="Phones" THEN " Tech/Phones"

      ELSE "None"

      END

       

      The sum of records has percentage of total selected across the table.

       

      So here i want to select the calculation1 in filter and when i select furniture then i want to see "15.01% " That is displayed in the above view and not the one shown below:

       

      prob2.png

       

      Please help !