show % evolutuion different products

[fran_perea]

I have several products, each of them has a % of sales.I want to display the evolution in another chart. But when i try to do it the cahrt is like this one:

As you can see the % doesn´t match between graphs. The Set Analysis formula is the same. 

(sum({<[Operation]={'Sale'},Year,MonthYear, [Wallet ID]={'A','B', 'C', 'D'}>}Amount)
-
sum({<[Operation]={'Return'}Year,MonthYear, [Wallet ID]={'A','B', 'C', 'D'}>}Amount))
/

(sum({<[Operation]={'Sale'},Year,MonthYear, [Wallet ID]={'A','B', 'C', 'D'}>} Total Amount)
-
sum({<[Operation]={'Return'},Year,MonthYear, [Wallet ID]={'A','B', 'C', 'D'}>} Total Amount)

Any guess what im doing wrong?

Thanks

[marcus_sommer · Accepted solution]

You may try it with:

... Total <Year> Amount)

to consider at least one dimension - the Year - by the calculation (depending on requirement you may add Product respectively switch between dimensions).

[fran_perea]

The bar chart is the good one, the % of the Blue one should be 76% in 2023, not 25%. 

With the solution you suggested there is an error in the expression. 

[marcus_sommer]

There should be no error - did you an appropriate adjustments of the total statements within the expression?

[fran_perea]

Yes, my bad. I didn´t introduced it properly. Now is working fine.

Thanks a lot!