Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
One of my simple expression i have used in my pivot table is shown below.
ROUND (RANGESUM (BRO_COMM,AGE_COM,+GRO_COM,-TOT_COM))
I want to hide or remove the zero values shown as a result of above expression without considering the results of the other expression.
So can you any one help me to find the effective formula instead of the above or what modification i could do.
Thanks.
Priyantha.
not successful,
You need to post an example app
Do you mean that if BRO_COMM=0 then the value for BA00 should not be visible? no matter AGE_COM and other columns have values?
No dear,
The outcome results of the above expression = 0 then that raw should not be shown in the pivot table, not considering the results of the other expressions.
I have opened a new discussion and posted the sample Qvw file also for your easy referance.
If(ROUND(RANGESUM(BRO_COMM,AGE_COM,+GRO_COM,-TOT_COM))<>0,ROUND (RANGESUM (BRO_COMM,AGE_COM,+GRO_COM,-TOT_COM)),'')
