Skip to main content
Topics#Tableau Desktop & Web AuthoringPergunta de Ratna Sari
Ratna Sari perguntou em #Tableau Desktop & Web Authoring
22 de abr. de 2018, 04:51

How to get the final value based on center period and %growth in tableau

Hi,

 

I have this scenario, there are 3 parameters in my tableau workbook for user to change the value  

I have data source like this:

 

My Requirement is to produce column value based on the parameter (ex: for year 2023, the based value is 100). and the subsequent year is based on the based year +/- the growth.

 

Please find the attached file for the sample workbook

 

Thank You

5 respostas
  1. Hari Ankem (8x Tableau Ambassador)
    22 de abr. de 2018, 05:46

    You can use this formula to derive the values as required:

     

    [Based Year Value]*((1+SIGN([DiffYear])*[Yearly Growth])^ABS([DiffYear]))

     

    You can use this formula to derive the values as required: [Based Year Value]*((1+SIGN([DiffYear])*[Yearly Growth])^ABS([DiffYear])) A 10.5 workbook is attached. Hope this helps.

     

    A 10.5 workbook is attached. Hope this helps.

Escrever uma resposta...
0/9000