Home > OLAP Calculation Templates > Prior and Future Periods > Percent Difference from Pri...
![]() Previous |
![]() Next |
Returns the percent difference between the current value and the value of an earlier time period.
Percent difference from prior period for measure (...) in the time dimension and time hierarchy hierarchy number period ago.
This calculated measure computes the percent difference between the current value of Units and the value for the previous time period.
Percent difference from prior period for UNITS(...) in the TIME dimension and TIME.CALENDAR hierarchy 1 period ago.
The Pct Change column shows the percent difference between the current time period and the previous time period. A Prior Period calculation computes the values of the Last Period column, and a Difference From Prior Period calculation computes the values of the Change column. The calculations include more quarters and years than are shown here.
Time Level Units Last Period Change Pct Change ------ -------------------- ------- ----------- ------- ----------- Q1.05 CALENDAR_QUARTER 143607 149528 -5921 -.04 Q2.05 CALENDAR_QUARTER 138096 143607 -5511 -.04 Q3.05 CALENDAR_QUARTER 138953 138096 857 .01 Q4.05 CALENDAR_QUARTER 145062 138953 6109 .04 Q1.06 CALENDAR_QUARTER 146819 145062 1757 .01 Q2.06 CALENDAR_QUARTER 145233 146819 -1586 -.01 Q3.06 CALENDAR_QUARTER 143572 145233 -1661 -.01 Q4.06 CALENDAR_QUARTER 149305 143572 5733 .04 2005 TOTAL 565718 587419 -21701 -.04 2006 TOTAL 584929 565718 19211 .03