Equating variable to a function in set analysis

[chhavi376]

Hi all,

I have a data set with date wise data of Districts and their corresponding territories.

The territories and the corresponding district has the same alphabet in common.(G in case of the example attached).

But, i have some more territories(which belong to some other district) but are temporarily aligned to this district.

My requirement is, that i don want to aggregate the data of this territory in the rollup, but the data of this territory should show up only when that territory is selected.

I don want to hard code this, as there will be numerous cases in the actual dataset.

I am trying to put this in set analysis, using wildmatch/mid function so that i can compare the Alphabet in the territory and the district.

But i am facing problems in the same.

Please have a look at the attached sample.

Thanks