I'm having a problem with one of my calculations. It's working perfecty for one selected unit (e.g. year '2010', or quarter 'Q2' for year 2010, or month 'july' for year 2010).
But, in my report in Excel, I MUST have option to select multiple values of date (e.g. quarter 'Q1' and 'Q2', or months 'january' and'february') because some other of my calculation needs multiple values of date.
What I need is to tell me how to change my calculation when I chose multiple values of date? Is it even posible?
-if you select three months: 'january', 'february', 'march' then I want last month 'march' to be saved in some variable (or if there is some other method, even better) that can be used for making SUM of Amount on period (from begining to latest selected
date) described in code below.
[Date].[Year - Quarter - Month - Date].CurrentMember,
[Date].[Year - Quarter - Month - Date].[Year]
IIF([Date].[Year - Quarter - Month - Date].CurrentMember.Level.Name="Year"