This content has been marked as final.
Show 2 replies
-
1. Re: How to create calculated field based on data in different rows
Matt LuttonOct 28, 2013 9:24 AM (in response to Alissa Anderson)
See the attached. With the view set up as Date > Place > Sum(Rate) on the rows shelf, duplicating the Sum(rate) and choosing Quick Table Calc > "Difference", then customizing/editing that table calc to create a calculation (named Difference in this example) that will be available in the data window. This table calc is set up as addressing: Place, partitioning on Date.
If you have any questions or need help applying this to your actual workbook, don't hesitate to ask or post your actual workbook along with the desired outcome you'd like to see.
-
2. Re: How to create calculated field based on data in different rows
Ramon Martinez Oct 28, 2013 9:49 AM (in response to Alissa Anderson)Hi Alissa,
As Matthew said. He was quicker than me.
This is a variant of the same concept explained by Matthew. Check the attached workbook.
Best,
Ramon