1 Reply Latest reply on Aug 31, 2016 12:37 PM by Santiago Sanchez

    how can i make a calculed field with condition of one filter?

    Shengdu HUANG

      Hello,

      This is my original table:

       

      Now i want to show the sum(criteria) with filter like this:

       

       

      But i want it shows by default the sum of First Name and Last Name as usual even nothing is selected, not sum=0,  like this:

       

      Is it possible???? Thanks in advance.

        • 1. Re: how can i make a calculed field with condition of one filter?
          Santiago Sanchez

          When you clear the selection on filter, all data is removed and so there's nothing for Tableau to render on a sheet. Therefore, we probably need 2 sheets.

           

          In the workbook attached there's a new one called 'Default' with a selection for First and Last Name. From there, you can use floating order in the dashboard so that the default sheet is all the way to the back, behind the 'Feuille 1' sheet. When nothing is selected on the filter, the Default sheet appears!

          1 of 1 people found this helpful