-
1. Re: NEXT button in a Single Sheet Drilldown
Bryce Larsen Jul 30, 2018 9:27 AM (in response to Bryce Larsen)UPDATE: originally I thought I had it working - and it does for the first 'Next'.
I needed to change one of the fields it was joining on, but, most importantly, the action filter was on Show All Values instead of Leave the Filter.
Main issue: once you click 'Next' once, there are multiple 'Current Levels'. In this example, clicking next from the start makes the Current Level become both "Massachusetts" and "Rhode Island". As such, when you click it again, it will pass the first one alphabetically (Massachusetts in this case).
This is not the desired behavior. I would hope clicking it again would make the 3rd level/view show ALL cities within the data (for both states).
Any ideas?
-
2. Re: NEXT button in a Single Sheet Drilldown
Bryce Larsen Jul 30, 2018 1:29 PM (in response to Bryce Larsen)To demonstrate:
Main view:
Next button passes both states (great!):
Then Next button only passes first value that appears alphabetically (only Massachusetts is passed, hard to see, but trust me! Heh):
I understand why this is happening ('Current Level DSC' is on detail pane and it's stacked upon itself in the button biz), but curious of a way to pass all rows.
One solution is multiple sheets that uses a WINDOW calc to determine whether or not to show and each sheet links on something else, or perhaps a LOD expression. However, the former is more work to maintain in my real workbook and the latter can be memory intensive and affect performance. Any suggestions appreciated!