Thanks a lot for your answer, it helped me.
The only last problem is that I need to apply different filters on these duplicated Data Sources because the only calculation it's able to do for the moment is : Raw Amount without any filter - Amount with the filter that i choose.
I need to apply different filters to these 2 different sources to operate the right calculation.
I want a filter on the primary source (orange), and another one on the secondary (blue).
I can't do it, is it possible to do so ?
1 of 1 people found this helpful
Follow up with these:
I think this will solve your problem.
Thanks a lot for your help, I managed to do the job.
I have a last problem.
I want to substract a last variable in my calculated field, wich returns an empty field (the filter that I add on this last duplicated dataset returns an empty result in some cases).
I think that I need to use the ZN function on my last duplicated database to return 0 instead of empty, but even when i do so, it doesn't work.
Do you have any ideas ?