Displaying the previous month (december 2018) and all the months of 2019 in SAP Lumira Designer

[friedrichherve_lien]

Hello experts,

I´m am facing the following challenge:

I have 4 key figures which must be displayed in a stacked column chart in SAP Lumira Designer.

The x-axis should start with december (which is the last month of the previous year, e.g., 2018) followed by January, february... december of the current year, e.g, 2019.

In Query Designer, I used respectively 13 selections for each key figure.

In the first selection, I restricted the key figure with the previous month december. I did the same for the last 12 selections (january till december) using the corresponding variable.

Unfortunately, I´m not able to get the required result.

Can anyone help me accomplish this?

Many thanks

[reiner_hille-doering]

Hello,

this sounds like a simple dimension filter - filtering the YEARMONTH dimension to the 13 months - assuming you have such dimension.