# Time Measure Expression Use Cases.

Example 1: Apply Time Measure Expression to show difference, difference of percent, and cumulative.

> DataItem timeItem = ds.newDataItem();
> ds.addBusinessItem(timeItem);
> ds.addResultItem(timeItem, Role.COLUMN);
> TimeExpressionMeasure timeMeasureExpression = new TimeExpressionMeasure();
> timeMeasureExpression.setMeasure(numericExpression); <<== where numericExpression is Sum of Quantity
> timeMeasureExpression.setFunction(TimeExpressionMeasure.PERCENTCHANGE_PREVIOUS_PERIOD);
> timeItem.setExpression(timeMeasureExpression);
> timeItem.setLabel("Percent");
> timeItem.setFormat("PERCENT10.2");

> DataItem timeItem1 = ds.newDataItem();
> ds.addBusinessItem(timeItem1);
> ds.addResultItem(timeItem1, Role.COLUMN);
> TimeExpressionMeasure timeMeasureExpression1 = new TimeExpressionMeasure();
> timeMeasureExpression1.setMeasure(numericExpression); <<== where numericExpression is Sum of Quantity
> timeMeasureExpression1.setFunction(TimeExpressionMeasure.DIFFERENCE_PREVIOUS_PERIOD);
> timeItem1.setExpression(timeMeasureExpression1);
> timeItem.setLabel("Difference");

> DataItem timeItem2 = ds.newDataItem();
> ds.addBusinessItem(timeItem2);
> ds.addResultItem(timeItem2, Role.COLUMN);
> TimeExpressionMeasure timeMeasureExpression2 = new TimeExpressionMeasure();
> timeMeasureExpression2.setMeasure(numericExpression); <<== where numericExpression is Sum of Quantity
> timeMeasureExpression2.setFunction(TimeExpressionMeasure.CUMULATIVE);
> timeItem2.setExpression(timeMeasureExpression2);
> timeItem.setLabel("Cumulative");

Example 2: Apply Time Measure Expression to show cumulative starting from 2000.

DataItem timeItem = ds.newDataItem();
ds.addBusinessItem(timeItem);
ds.addResultItem(timeItem, Role.COLUMN);
TimeExpressionMeasure timeMeasureExpression = new TimeExpressionMeasure();
timeMeasureExpression.setMeasure(numericExpression); <<== where numericExpression is Sum of Quantity.
timeMeasureExpression.setPeriod("[Time].[YQMD].[All YQMD].[2000]");
timeMeasureExpression.setFunction(TimeExpressionMeasure.CUMULATIVE);
timeItem.setExpression(timeMeasureExpression);
timeItem.setLabel("Cumulative");