-
1. Re: Year over year growth
Shinichiro MurakamiSep 12, 2018 2:07 PM (in response to GeneBurns)
Hi GeneNurns
I'm not quite gotten what you want.
Are you talking about specific worksheet in you book or it's not created?
Could you illustrate what is current issue and what is your expectations.
Thanks,
Shin
-
2. Re: Year over year growth
GeneBurns Sep 12, 2018 2:16 PM (in response to Shinichiro Murakami)I'm trying to get the correct growth rate (shown as 1205.7%, this is not correct) in the chart linked to above (photo shown below). Previously I've used the formula below and computed on the cash fiscal year, but that isn't working with this setup. Does this help?
(LOOKUP([Running Sum],0)-LOOKUP([Running Sum],-1))/LOOKUP([Running Sum],-1)
-
-
4. Re: Year over year growth
GeneBurns Sep 12, 2018 2:25 PM (in response to Shinichiro Murakami)Sheet 14
-
5. Re: Year over year growth
Shinichiro MurakamiSep 12, 2018 2:35 PM (in response to GeneBurns)
Seems like kind of bug on public. it shows incorrect value on your link. but
With changing the table calc to this way, public on my page shows correct value,.
https://public.tableau.com/views/testGeneralFundpost/Sheet14?:embed=y&:display_count=yes&publish=yes
Thanks,
Shin
-
-
7. Re: Year over year growth
Shinichiro MurakamiSep 12, 2018 2:38 PM (in response to GeneBurns)
Confused, what's the right value?
Shin
-
8. Re: Year over year growth
GeneBurns Sep 12, 2018 2:48 PM (in response to Shinichiro Murakami)Shin, I think I figured this out. I needed to change the nested table calculation for "running sum" within the year over year value. I'm going to do some double checking and mark this as answered. Thanks!