One of the most common calculations is calculating the percentage of the current value to the total one level up. For instance [Measures].[Sales Amount] for the quarter compared to the semester.
This gives use several challenge's.
1. What is the total amount one level up. With the .CurrentMember property we know where we are. If we combine this with the .Parent property we can calculate the total amount: ([Measures].[Sales Amount],[Date].[Calendar].CurrentMember.Parent) .
Showing posts with label Percentage. Show all posts
Showing posts with label Percentage. Show all posts
Sunday, August 3, 2014
Subscribe to:
Posts (Atom)