Getting my data broken down by states?

https://drive.google.com/file/d/1xWl-pLZ3m6xinlepSwWI1j7mRxaTJjxl/view?usp=sharing

So I get how to group regions in for the PF elite tab, and that works great. What I dont get though is in the tap for region, I want to show by region and the states within the region, but if i do a new group it will only show region names on the x axis not state names. i tried fixing but it wont group to show that. Additionally, I am lost how to do a correct formula for pf elite, the var change. i see the number change but i want to say this is my percent change year over year. it keeps giving errors. 

Where did you add the regions in this file???

hi sorry wrong file it is 7.8 the groups are there in the file now

My Drive - Google Drive

https://doc-04-1s-docs.googleusercontent.com/docs/securesc/o5p4qtjd3e4qgqsh90ir7pkkjs90l883/r5oouhfa0btmv0oshbndh401137ivi4d/1625858250000/16399674288978596393/16399674288978596393/1ZvLbRQEltYv4i3hbo_EdA94c_IVqv4yW?e=download&authuser=0&nonce=khulmvon6gk5g&user=16399674288978596393&hash=c6isu05nuvpd2m67tk8gjce1uugcv394

but i dont get how to basically drill down in the region in the region tab to be able show ok, this region and you can see the states listed. it only shows region. i tried doing a new group called west, with only those states but it still only will show the region, why is that?

for emaple it will show the states of the region i select in the charts but it only highlights them against the other states, shouldnt it show just those states?

https://drive.google.com/file/d/1ZvLbRQEltYv4i3hbo_EdA94c_IVqv4yW/view?usp=sharing

Hi bv27718n ,

You could add both region and state to x-axis and use drill down feature at the top right of the visual.

Best Regards,

Jay