I have a Dynamic View built from a report of multiple sheets.
I am able to build logic in the DV based off a set of dropdown fields from one set of the sheets, as shown here:
But when I try to do the same for another set of the sheets in the report, which has dropdown fields set up exactly the same way, there are no values available in the logic view, as shown here:
I confirmed all of the PLG sheets have the field set as a dropdown with the same values entered, just like in the SLG sheets that are working to build logic in the DV.
I've tried to search why this may not be working; all I have found are posts that suggest this shouldn't be working at all since I'm using a report with so many different sheets that do not all have the same fields. But the SLG dropdown fields, just like the PLG dropdown fields, are not present in all of the sheets in the report.
What else can I try? Thank you!