Skip to main content

Dear all,

 

I am a beginner to Tableau and I first apologize if this might be a repeat of the questions raised before. I will try my best to be concise.

 

I am facing a problem where I am trying to get a new calculated row to appear based on a 5-Year period CAGR that can be changed using a filter I have.

 

Here is my current table I am working on:

Creating additional calculated row

Basically, the Year Filter changes the number of years to display, and the Country Filter changes the information displayed. I am hoping the additional row that I need will change based on the Country selected.

 

I am intending to create a row at the bottom that calculates the 5-Year CAGR value that looks something like this in Excel:

Capture.PNG

If need be I can furnish more details. But I hope you guys can understand the gist of my problem. I am not very familiar with the coding and formulas involved with Tableau too. Thank you in advance!!

5 answers
0/9000