How to Suppress Zero values in Straight table based on Button selection ?

[narayanaqlik]

Hi Experts,

I am facing one issue in straight table to suppress the zero values based on the external button selection (Not Check the Suppress Zeros in Presentation tab).

I have table like the below

                                                                          SuppressZero,  All Values

 Account_ID,  ActualDate, TransforDate, Charges, CD, Discount, NetRevenue(Charges+CD-Discount),  NetPayments, Balance (NetRevenue-NetPayments)

101,                  10/11/2022,   23/11/2022,         500,    50,    30,             520,       460,      60

102,                  11/11/2022,   24/11/2022,        450,     100, 50             500,         500,       0         

103,                  12/11/2022,    25/11/2022        350,     0,      100,         250,        250,        0

104,                  13/11/2022,     26/11/2022,     650,      150,    0,        800,        900,      -100

I have My data like the above, when i click on Suppress zero button here i don't want see the records (102,103)with zero values in the Balance column records, If i click on All values button then i could see all the values in the table.

Don not click on the Suppress Zero values in Presentation tab.

Could you please help here how to approach.

Thanks in advance 

[Or]

As far as I know, you can't actually do this directly. Your best bet would be to create two separate tables, one with Suppress Zero enabled and one where it is disabled, and then use a button / variable to toggle which one is shown.