can you advise me on the below issue?, Issue is I have a table with Group and KPI as fields.
LOAD * Inline [
Group CL ED HV IE SB ]; Join A: LOAD * Inline [ KPI To From Country ];
whenever I open the application it should show KPIs "From" and "Country" with default selection as From and all the groups. then when I select "CL" in the list of groups, KPI should show "To" and "country" and the group "CL".
Ideally, when I select groups other than "CL", KPI should show From and Country, if the group is "CL" it should show "To" and "Country" , if the previous selection in KPI is "From", upon selection of "CL" group it should show "To" if it is country there shouldn't be any change in KPI selection.