Displaying a Table based on User filter selection

[Kandimal]

Hi All,

I have a peculiar requirements from my stakeholders,

I have a table and 4 filters in my sheet. Initial requirement was to make the sheet to display based on Customer_ID Selection and was achieved using GetSelectedCount(Customer_ID)>0.....Now user wants to expand this to other filters as well, where by default the table should show a message "please select atleast one filter" and post selection, the table should be filled with user selected data.

[chrismarlow]

Hi,

If they want it to show if any of the fields has filters can you string them together with OR? e.g.;

GetSelectedCount(Customer_ID)>0 OR GetSelectedCount(Other_ID)>0

Cheers,

Chris.

[Kandimal · Accepted solution]

Hi Chirs,

@chrismarlow 

Thanks for the input. Suggested approach was already used in the report. that was due to the if else statements in side the filter columns in the front end app.

To overcome this, As a turn around solution, i have moved all the calculations to back end and calling final columns in the front end and on top applied 

GetSelectedCount(Column1) or GetSelectedCount(column2) and gave me the desired results.

Thanks