Set Analysis Previous level of hierarchy

[rainstorm9]

I am writing a set analysis to get the count of customers in a region. I have the hierarchy as: country->region->area. When an area is selected, I want to do a count of the customers within the region that this area belongs to, in a text object.

Currently I created a variable as vRegion: only({$<Area={'$(=GetFieldSelections(Area))'}>}Region)Then in the set analysis: count({$<Region={'$(=$(vRegion))'}, Area=>} Customer_Name)

Is there any simple way of doing this instead? Thanks in advance!

[sunny_talwar · Accepted solution]

Try this instead

Count({$<Region = P(Region), Area>} Customer_Name)

Read about P() and e() here

[rainstorm9]

Thank you Sunny!