hi I would like to make a graph like a picture below.
I want to to know about how to make a row parrellel.
rows dimension is ‘time’ dimension.
time dimension which i defined is below.
19년4차(1) = Aggregate(
19년4차(2) = Aggregate(
There is a standard function to have the data of parallel periods. You can check this function here in the documentation: https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members/mdx-function-reference/parallelperiod.
This function, however, has a limitation that it works only on the members of the standard hierarchy of Time dimension. That will not cover your case, unfortunately.
The solution for your case would be to hardcode the parallel periods in the calculation with a case statement like this:
"My custom time member" THEN
[Time].[My custom time member parallel]
Janis, eazyBI support