Help in bar chart to show total on one dimension

[#1]

Hi all,

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).

Thank you