it is possible - but not in a single expression. Like I have said, the values can only be populated once - e.g., they can only be matched against one text in one expression. Once the values are "taken", they are gone.
You need a second expression (a second field) to match them against some other text.
How would you want to do in your chart? What should it look like?
Again, knowing where you want to go makes it easier for others to tell you how to get there.
Best regards,
DataNibbler
P.S.: Oh - and independent of this, if you use a PICK(MATCH()) function in your expression instead of all these nested IF_clauses, it makes the whole thing much easier to reconstruct or maintain (later or by someone else) - rgd. the bracketing. In a PICK(MATCH()) function, each line is closed off for itself, so there are not 7 closing brackets in one point ...
I guess I understand. So you want to have two dimensions in your chart so that the user can drill down in the data from the Total into the parts?
That is not possible either in one chart or in one field (GUI-level vs. Scripting_level) - you can apply that MATCH() or WildMatch() function in the script or on the GUI, but you can only match one value with one text in one expression. So you need two similar Wildmatch() functions which will make up two dimensions - it is more resource-friendly to do so in the script, but it will work on the GUI.
With the PICK(MATCH()) it would look roughly like this:
