You can build a dimension based on the criteria they're gonna split and then use it, right?
I have to split one measure to another two measures .
In forum, people have used only one measure eg Sales and that Sales is flows between two dimension eg Category to region etc.
What is the condition for splitting one measure into two other measures?
Currently I am using static image as decision tree which I have attached in my post and numbers are calculated fields based on condition.i have used these numbers in sheet and these sheet used on image as floting in dashboard.
Now requirement is change static tree to dynamic.