I have created a sheet with table and filter pane, when i select the value in filter pane the counts in the table is filtering properly,
When it is not selected anything in the filter pane, it's displaying all the values from the db, how can i make it zero till selection is made in the filter pane.
Solved! Go to Solution.
Thanks for the reply,
My issue is for example i have a measure: count(invitation_id). when i select any client from filter pane, it will display the count of that client, if any client is not selected it will display the count of all client. Instead i need to display zero when no selection is made.