Required filter prompt VP, Regional VP, Sales Manager, Sales rep

Summary:

I am creating a filter prompt where I need to display VP, Regional VP, Sales Manager, Sales Rep as a dashboard prompt

Content (please ensure you mask any confidential information):

Ahmed is VP

Abdullah/Kareem/Farooq is Regional VP

each Regional having team of managers (m1, m2, m3/ n1,n2,n3/ o1,o2,o3)

Manager team m1 : sr1,sr2, sr3 and so on

m2 : sp1, sp2, sp3

m3: sq1, sq2

Prompt should depended. VP → Regional VP → Manager → Sales Rep

Regards,

Mohammed Hyder