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
Jul 6, 2017, 8:44 AM

Calculation problem - how to return the last row with a special value ?

Hi again the community,

 

One question regarding calculations on Tableau :

I have a field named boolean (with two values : 0 or 1). I would like to create a calculated field which returns the number of the current row (use of index()) if boolean =1 or the number of the last row for which boolean =1. Do you have any ideas ?

 

Thanks in advance,

 

Adrien

3 answers
  1. Tableau Community Forums Member (Inactive) (Salesforce)
    Jul 6, 2017, 10:58 AM

    Hi, Adrien

     

    If you could provide a sample workbook will be more helpful.

     

    I use super store as example attached.

    In the workbook, I try to find the last row of Q3 and flag as true.

    The result is like this

    Hi, Adrien If you could provide a sample workbook will be more helpful. I use super store as example attached.In the workbook, I try to find the last row of Q3 and flag as true.

     

    Workbook attached with version 10.2.

     

    Hope this could help and please let me know if you have question.

     

    ZZ

Write an answer...
0/9000