I'm trying to understand if it is possible to reach the result without the use of valuelist function.
I have a main dimension (DIM) and a second dimension (YEAR). I would like to see which is the sum(VALUE) per each DIM on each year. That's fine but I would like to show the total value on each year.
Is it possibile without using the valuelist function? I have several values in DIM and would like to optimize the performances since the data to be processed is kind of big.
I attached the QVW with both charts (I need to reach the same result obtained by valuelist chart example).