Dynamic formulation for full year / rolling 13 months

Jona Löneke Still not sure what you mean. In your chart, the darker blue line is the amount per month. The lighter blue line (which is flat), is the total for the year, shown as the same number in every month? And you want the lighter blue to be the total of year in which the month falls in? 

NPANS, I guess I know what Jona wants to achieve: The two buttons above his charts work as a toggle button. When you click Gesamtjahr/Total Year the category axis should show Jan - Dec of the current/selected year. And when you click Rollierend/Rolling the category axis should show the last 13 months before the current/selected month.

So, he wants a dynamic visualization, I suppose, based on the status of the toggle button. And that's what he presented to us in his initial post - but hardcoded for the current year (cf. his screenshots with the formulas). 

I am not sure if the following post may help - it is about dynamic dimensions as well: https://community.pyramidanalytics.com/t/p8y69k0/tip-of-the-day-dynamic-dimensions-and-measures
Perhaps you can combine these ideas with the implementation approach ObeeOne has given...

Best regards,
Michael 

Jona Löneke Here is the solution. 

1. Create a new global parameter.
   1. I am using a "number" parameter with 2 discrete values: "Full Year" with value 0, "Rolling13" with value 1.
   2. Save
2. Create a new List "B" like before. Go straight into script mode and add the following logic.
   1. The list logic is a little complicated, but it says: (from the inside - out) find me a non-empty year from the year hierarchy members, based on my original month parameter and the sales metric. So if I choose "Jun 2024", it finds me the non-empty year that aligns with this, which should be "2024".
   2. We then take the year from the previous step, and put it inside another non-empty function, to find all the months that are not empty for that year. So now, the year 2024, will find all the months Jan-2024 to Dec-2024.
   3. Putting it altogether, our parameter will find all its sibling periods for a given year. without any complicated counting or hand-written elements.

   4. nonempty([Date].[Month].[Month].members,
       nonempty({[Date].[Year].[Year].members},
           ( [Date].[Month].@[5d9bcfea-4d70-48f0-a6b6-e348d737d3d8] ,measures.sales)
        )
      )

       

3. Create another list "C", to glue it altogether, in script mode.
   1. We use an IIF statement to check the parameter value. If 0, use the new list "B". Otherwise, use our original list "A" from above. In building your own syntax, find the parameters and lists in the metadata trees below the editor and drag and drop them into the editor (or double click to insert at cursor).

   2. iif([global].#[c1afc906-da28-4ff3-82ce-e9b9447af556]=0,
        [*77fbb048-5881-4dbf-99ca-22b6e16e0996*] ,
        [*6eeb183e-2a36-4532-a2b5-7173c2eddd8a*]
      )

       

Drop list C into Discover, you'll have 2 switches: 1 to control the months, and 1 to control the listing logic. And your chart problem is solved.

Jona Löneke It's hard to say what the error is. But List/set "B" is not correct. You are using months ("KJ Monat") in both nonempty functions. The inner one should be years, and the outer one months. 

However, I now notice that you are using a regular hierarchy for dates - not 2 attributes. Which means the logic I gave you is not correct anyway - since I assumed it was 2 flat attributes for months and years. 

So, instead, I would be using this logic for set B:

DESCENDANTS(
  [Date].[Month Dates].@[434e8e89-c44a-47e9-869a-15b98d6b264c].parent.parent,
  [Date].[Month Dates].[Month]
)

This takes the month from the parameter; finds its parent's parent (the year); and then get that year's descendants at the "month" level.