Sum expressions with different dimension field but having same dimension value
I have a problem with resolving the following situation. I have multiple geographic area's that are copied in multiple fields. Let's simplify the problem to two fields:
So the content of both thoose fields is the same = [Area1, Area2, Area3, ..]
Let's say I have 2 expressions (in reality they are little bit more complex):
I can perfectely make a chart that gives me an overview for 1 expression. But I cannot combine both expressions just like that in one chart because the dimensions differ that I have to use for both expressions. What I want to achieve is a chart that gives me:
I could do this with a data island as dimension and then using a nested if expression and hard coded 'Area x' values in the set analysisses but I've got alot of those area's to cover (not to mention expressions...)
Does anyone has an idea how to do this better? Thanks!