Include/Exclude Zero Values Dynamically

[Kailash_Shaw]

Hey!

I need a help to Include/Exclude Zero Values Dynamically. Probably based on Button/Variable Input selections.

I have this Pivot where 'Canutility' - 'DD' has 0 for both the measures. I can add/remove that row if 'Include Zero Values' button is checked/unchecked.

Can we achieve this with button on the front end? Clicking that button will include/exclude zero values.

Please suggest.

[Or]

I am not familiar with a way to do this directly, but you could consider a show/hide container containing two copies of the same object, one with zero values included and one without, and toggle them based on a button or whatever other condition. This does require you maintain two objects, though...

[Kailash_Shaw]

Thanks @Or, I will try that if app size permits.

[Or]

The impact an extra object has on app size is negligible, so that shouldn't be a problem. It's mostly the issue of maintaining two objects and potentially the issue of using a container and master items (which makes it harder for users to edit the object after duplicating, if that's a consideration).

[Kailash_Shaw]

Oh ok, got it, thank you!

[MayilVahanan]

Hi 

Try like attachment. 

Hope it helps

[Kailash_Shaw]

Thanks @MayilVahanan 
One query, how to make it work if I have multiple dimensions into table?
I am pasting your dimension expression here for quick reference.

=Aggr(If(vHideZeroValue = 1, if(Sum(UnitPrice)+Sum(UnitSales)>0, Product), Product),Product)

[MayilVahanan]

Hi

Try like below, 

Hope it helps

=Aggr(If(vHideZeroValue = 1, if(Sum(UnitPrice)+Sum(UnitSales)>0, Product), Product),Product, Customer)

[Kailash_Shaw]

Thanks experts!

I have found another workaround that suited me better in this app.

I have unchecked the Include Zero Values in add on properties and added additional field to hide/unhide zero values with variable input. Here are the screenshots for reference.