Development per month bar chart - Cube

[anwy]

Hi,
i need help with the correct approach. A bar chart shows the development of the same month of the previous year per month. The base is a power cube. Is it easier in the report or dashboard? The start time must be set dynamically by the user. Can the monthly change be calculated by calculated field in the report or better directly in the transformer.

Can someone give me jump start?

Thanks in advance.

Example of the chart attached.

[anwy]

Hi all,

i am not sure if the Problem was explained well  :-\

Is it possible to get the e.g. the "growth" of current month compaired to
the same month last year directly out of a power cube or do i Need to calculate it
in a Report?

[rockytopmark]

Build a crosstab first.  Try this layout:

Outer Column Edge: Selected Period (months) set
Nested column edge: Change from Last Year: 1- [some_measure_member] / tuple([some_measure_member], parallelPeriod([year level],1,currentMember(time_hierarchy)))
Rows... not sure, your call

This should give you what you are looking for, or at least give you a head start.  Then convert it to a visualization, and apply conditional formatting to get your desired colors.

HTH ... MK