Unfortunately, there is no easy way to move a dimension from the left side of the pane to right. One way we can work around this is conditional crosstabs.
Please find the attached workbook.
If you need help going through this, please let me know.
Show City on Right Pane.twbx 1.2 MB
Just wanted to see if the solution I gave was working for you.
If not let me know and I'll be happy to help you through it.
Thank you for following up. It is very closer to the ask.
I see that you have placeholder 1 and max city. I haven't been able to make it working on my end. Unfortunately we are still in client 8 :-(.
and my data set is different from superstore. would we be able to set up sometime to go over it over the phone?