Do you have any sample workbook to share.
If it is working in lower versions it must work in 10.5 as well. Is it possible to attach a sample .TWBX file? It will always help.
Please see attached twbx. I used Superstore as data source.
in the .twbx file, the issue is with Total Qty, if I clicked any of the Region its working to show the Details but when I clicked the Total Qty its not showing the complete list of Region.
I suppose you want to achieve is when you click on region (from Region Breakdown worksheet) then Details sheet should give you only list for that region (sales in each state for that particular region). Now you want to click on Total Quantity with purpose that it should give you back all the regions and states with their sales.
To achieve this, you have to edit the action filter:
for superstore data :
1. Click Dashboard > Actions : this will open a dialogue box for editing action filters.
2. Edit Filter1, this will again open a dialogue box (Edit Action Filter)
3. At botton, you will find Target filters, check on "Selected filters" instead of "All fields", then Add filter- select Region from the list and save the edits.
This will do the job for you.
attaching the tbwx file for your reference.
Hope this helps you