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
Jan 14, 2023, 4:36 PM

Hi All, I am attaching the excel sheet below. I would like to achieve same results as "Qty plus rollover" and "Tail from Previous Day" columns using tableau. I tried to use the PREVIOUS_VALUE and LOOKUP function in tableau but its not working

I have attached the tableau work book as well for reference.

Tableau_Tail_Calculator.xlsx
2 answers
  1. James Emery (Georgia Tech)
    Jan 14, 2023, 5:33 PM

    @swathi karanam​ 

    I created a capacity field, but you could also hard code the value or

    For the Drop (Qty) + Rollover, 

    IF (PREVIOUS_VALUE(SUM([Drop]))-[Capacity])<0 THEN SUM(Drop)
    ELSE SUM(Drop)+(PREVIOUS_VALUE(SUM([Drop]))-[Capacity])
    END

    For 'Tail from Previous Day', it is just the previous calculation minus [Drop]. 

    [Drop  + Rollover]-SUM([Drop])

     

    @swathi karanam​ I created a capacity field, but you could also hard code the value or For the Drop (Qty) + Rollover, IF (PREVIOUS_VALUE(SUM([Drop]))-[Capacity])<0 THEN SUM(Drop)ELSE SUM(Drop)+(PREVIO 

    James Emery

    Tableau Forum Ambassador

    Once a response addresses your problem, please click 'Select as Best' so future users can quickly find the answer.

Write an answer...
0/9000