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
Sep 24, 2018, 2:35 PM

Custom Aggregation Help

Hi,

    

AccountSales Rep     $ DateAcme 1John1001/01/2018Acme 2Jack1001/04/2018Acme 2Jack2020/06/2018Acme 1John521/06/2018Acme 2Sam101/09/2018

 

I need to aggregate this such that the last sales person for the Account gets all the $ revenue associated to them. For example the above would aggregate to this:

 

Account

Sales

Rep

      $Acme 1John15Acme 2Sam31

 

How could I do this?

 

Thanks in advance!

 

Sam
8 answers
Write an answer...
0/9000