How not to show lines with 0 in specific columns in a pivot table in a dynamic app?

[nenadvukovic]

Hi, I welcome any idea. Thanks

[#2 · Accepted solution]

with a custom dimension:

if( aggr(sum(Value),Dimension)<>0,Dimension)

and check the Suppress if null flag.

[MayilVahanan]

Hi

Try with if condition or set analysis in expressions something like this

= if(Sum(Sales) > 0, Sum(Sales))

or

Sum({<Dimension = {"=Sum(Sales)> 0"}>}Sales)

Here Dimension represents the first dimension in the pivot table.

Need to include in all the expression.

Or

Try with calculated dimension.

if( aggr(sum(Sales),Dimension)>0,Dimension)

and check the Suppress if null flag.

Again u need to include in all dimension.