on 2024 Jul 02 3:50 PM
Hello,
the requirement is rather simple, but i am not yet very experience in advanced formulas.
I want to select a month of a specific year (defined as dynamic parameter) and then select a year (or year as the node of a date hierarchy).
Then this monthly value should be copied to every month of the selected year.
How is this possible with advanced formula?
Thank you!
Request clarification before answering.
I just figured it out myself, this is the code:
MEMBERSET [d/Measures] = "VALUE_PROJECT"
MEMBERSET [d/Date] = BASEMEMBER([d/Date].[h/YM], %TARGET_YEAR%)
DATA()=RESULTLOOKUP ( [d/Date] = %SOURCE_MONTH%)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
74 | |
30 | |
9 | |
7 | |
7 | |
6 | |
6 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.