1 Reply Latest reply on Feb 13, 2019 5:04 AM by Jim Dehner

YTD & AOP & Forecast table

emily nguyen Feb 13, 2019 4:07 AM

Would anyone have any tips on trying to replicate this kind of table in Tableau ?

Project	YTD AOP	YTD Actuals	Variance	Full year AOP	Year to date Actuals + Year to go Forecast	Variance
1	3	2	1	50	25	25
2	4	2	2	23	21	2

Below is also an example of my current data source (thought it extends out for 12 months)

Project	AOP	January Actuals	February Acutlas	March Actuals	Jan Forecast	February Forecast	March Forecast	January AOP	February AOP
1	50	1	2	4	5	4	4	3	4
2	23	4	5	23	1	2	4	4	6

Thanks in advance

1. Re: YTD & AOP & Forecast table

Jim Dehner Feb 13, 2019 5:04 AM (in response to emily nguyen)

good morning
interesting
please post your twbx workbook to show us your progress and where you got stuck -
Jim
Like Show 0 Likes(0)

Actions

Tableau Community Forums