
1. Re: Calculated ratio
Tracy Rodgers Jun 6, 2012 2:23 PM (in response to Michael Nealey)1 of 1 people found this helpfulHi Michael,
One way to do this is to create a table calculation similar to the following:
(ZN(SUM([Profit]))  LOOKUP(ZN(SUM([Profit])), 1))
Then, depending how the view is set up, the calculation will need to change how it is being computed. So if Year(Order Date) and Month(Order Date) were both on the rows shelf and this calculation was on the text shelf, right click and select Edit Table Calculation. Compute Using>Advanced. Add Month of Order Date and Year of Order Date to the Compute Using box. Then, place Year of Order Date at the level and Month of Order Date for Restarting every.
Hope this helps a bit!
Tracy

2. Re: Calculated ratio
Michael Nealey Jun 8, 2012 6:56 AM (in response to Tracy Rodgers)Hi Tracy 
Thanks for your answer...the calculation seems to work but if I wanted to show this with a continuous line, it seems more difficult and the calculation fails...(since I can't show both the quarter and year pills at the same time)...
Mike

3. Re: Calculated ratio
Michael Nealey Jun 10, 2012 6:49 AM (in response to Michael Nealey)To clarify my response, I cannot seem to get the correct calculation in a continuous date; I can make it work with a discrete date (blue pill), but this does not give me the view I am looking for.
Is there a different calculation I need to create for a continuous line?
Thanks!

4. Re: Calculated ratio
Joe Mako Jun 23, 2012 7:35 PM (in response to Michael Nealey)Can you provide a sample packaged workbook that represents your situation?