December 2019
Beginner
370 pages
8h 9m
English
If we changed the options to Compute Using Table (Down then Across) and Relative to Next, we could get drastically different results:

Because we are going Down then Across, we are calculating a percentage difference for all quarters compared to the next year (going down takes us through the years for a given quarter). The exception is for Q1–Q3 2014, where we would get the difference compared to the next quarter in 2011; because there is no following year for the given quarter, we are going across to the first year of the following quarter. In this case, we are comparing $85,110 in Q1 2014 to $48,501 in Q2 2011.
We ...
Read now
Unlock full access