Data island

[gauthamchilled]

I have a data island like the following

Tab1:

Load * inline
[Period
Quarter,
Half Year,
YeartoDate
];

and calendar table separately.

i want a filter listbox, if I select Half year in period listbox, it should show only June and September in Month listbox, if I select Quarter, it should show only Mar,Jun,Sep and Dec in the same Month listbox.

How can I achieve this?

[Gysbert_Wassenaar]

I don't understand the logic at all, but you can try using the Field trigger of the Period field and assign a Select in Field action to it that makes the selections you want. Or perhaps it's easier to create bookmarks for your selections and use a Apply Bookmark action instead.

[jonas_rezende]

Hi, Gautham Prasad.

See if the qvw attached helps.