1 of 1 people found this helpful
You can support multiple Business Units in the view by adjusting the table calc addressing / partitioning.
Since you want to calculate year-over-year grow, you want the addressing (the rows over which the table calc function operates) to be at the year level. You want to do this for every combination of Site and Business Unit, so those fields should be on the partitioning side.
Click the pill 2014 Growth > Compute Using > Year.
I usually find the table calculation dialog easier to use. To get to this, click the pill > Edit Table calculation. The dialog has a helpful message describing how the results will be calculated. You can also see/set the partitioning and addressing explicitly by selecting Compute Using > Advanced in this dialog.
I am not able to get a number for those growth rates when there is no Sales in current of prior periods.
What do you want to show in these cases -- he growth rate when there are no sales is not really defined?
Thanks Jim. That helps. As far as "Not getting growth rates when there are no Sales in current for past periods", I am looking to get either a 100%, 0%, or -100% growth based on the current and period Sales.
- $225K Sales in 2014 and 0 Sales in 2013 will result in 100% growth
- $0 Sales in 2014 and $0 Sales in 2013 will result in 0% growth
- $0 Sales in 2014 and $100K Sales in 2013 will result in -100% growth
Also, how can I get Tableau to $0 instead of blanks for $0 Sales?
Thnaks in advance for your help.