Skip to main content
Topics#Tableau Desktop & Web AuthoringTableau Community Forums Member (Inactive)'s Question
Tableau Community Forums Member (Inactive) (Salesforce) asked in #Tableau Desktop & Web Authoring
Jun 26, 2019, 11:05 AM

New Supplier

Hi All,

 

How to find new supplier from the data set

 

Supplier Year

A        2018

B       2018

C      2018

A    2019

B   2019

 

The supplier which exist in last year not in current year is new supplier

 

C 2018     i need to get

9 answers
  1. Tableau Community Forums Member (Inactive) (Salesforce)
    Jun 26, 2019, 11:50 AM

    Hi Shanmuga,

     

    To make it dynamic for any new Supplier added in any year, i tried an approach with Table caluclations.

     

    Please find the attached workbook for reference.

     

    Hi Shanmuga, To make it dynamic for any new Supplier added in any year, i tried an approach with Table caluclations. Please find the attached workbook for reference.

     

    Kindly mark answered to close the discussion if this solution help you in solving your problem.

     

    Regards,

    Ravikiran S

Write an answer...
0/9000