Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I welcome any idea. Thanks
with a custom dimension:
if( aggr(sum(Value),Dimension)<>0,Dimension)
and check the Suppress if null flag.
with a custom dimension:
if( aggr(sum(Value),Dimension)<>0,Dimension)
and check the Suppress if null flag.
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.