Marcos has a PivotTable that shows revenue by quarter. He wants to calculate the differences between the revenue for one quarter and another. What can he do?
A) Ungroup the date field.
B) Create a calculated item.
C) Create a measure.
D) Change the summary function to SUMGROUP.

Question

Quizplus · Accepted Answer

Marcos can create a calculated item in the PivotTable to calculate the difference between revenues for two quarters. He can do this by selecting the two quarters he wants to compare and then right-clicking to select "Show Values As" -> "% Difference From" and selecting the base field as the previous quarter. This will create a new calculated item that shows the percentage difference between the two quarters.

Marcos Has a PivotTable That Shows Revenue by Quarter