Skip to main content
Topics#Tableau Desktop & Web AuthoringKumar Tejas Goda's Question
Kumar Tejas Goda asked in #Tableau Desktop & Web Authoring
Mar 20, 2020, 7:18 PM

Exclude Max Date sales value which are greater than 0.

Hello All,

 

How to filter the Max Date Sales value which are greater than 0.?

 

For eg. In the below image you can see cross tab chart of Sub Category and Three date columns like Jan19, Dec19 and Jan20. So I want to filter out the values which are greater than 0 based only on Jan 20 (Max Date).

 

Like -

Exclude Max Date sales value which are greater than 0.

 

Waiting for your response.

 

Thanks & Regards,

Tejas.

2 answers
  1. Deepak Rai
    Mar 20, 2020, 8:07 PM

    I had this:

     

    I had this: and got this by creating this calc and setting TRUE.

    and got this by creating this calc and setting TRUE.

     

    pastedImage_0.png

    Thanks

    Deepak

    If it Helps, Pl Mark it Helpful and CORRECT to Close Thread

Write an answer...
0/9000