I have a Dashboard which I´m filtering by Fiscal Year and Fiscal Period.
I´ve created 2 BAQCombo boxes and the corresponding BAQs. The first one query and group FiscalYear from the APInvHed table, displaying the list of available years.
the second, do the exact same thing but with fiscal period and i added a calculated field to display month name instead of number.
so far this is fine, but i want to filter the Period BAQCombo, to display only the FiscalPeriod available based on the FiscalYear BAQCombo value, is that even possible?