How can you create a dynamic variance using standard Analysis for Office features?

A user has measures containing plan and actual data within the columns of a crosstab.

How can you create a dynamic variance using standard Analysis for Office features? Note: There are 2 correct answers to this question
A . Use a New Line rule type
B . Use an MS Excel formula.
C . Use a VB script
D . Use the Calculation from the Analysis ribbon.

Answer: A,D

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments