» Unlabelled » You need to create a report displaying a year-to-date aggregation on sales revenue across all months. The report should be sectioned on Region. Additionally, you would like to reset the running aggregation to restart for each Region. Which syntax should you use to accomplish this task?

Sunday, 21 April 2013

You need to create a report displaying a year-to-date aggregation on sales revenue across all months. The report should be sectioned on Region. Additionally, you would like to reset the running aggregation to restart for each Region. Which syntax should you use to accomplish this task?

A.   =RunningSum([Sales Revenue], Region)
B.   =RunningTotal([Sales Revenue], Region)
C.   =RunningSum([Sales Revenue] ; ([Region]))
D.   =RunningTotal([Sales Revenue], Reset[Region])

Ans: C


at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)