Hi
I have a crosstab column in my report that calculates the % of the two nested columns in the crosstab at the end under totals column. It works fine. But I have a requirement wherein I have to supress rows with zeros. When I give a filter saying [measure]>0, it works but my percentage column is not getting calculated correctly. It calulates for invidual columns and sums up instead of calculating % for the sum of the columns. I have tried giving solve order. It works only at the summary footer. The data source is OLAP. Would appreciate some help on this.
R
I have a crosstab column in my report that calculates the % of the two nested columns in the crosstab at the end under totals column. It works fine. But I have a requirement wherein I have to supress rows with zeros. When I give a filter saying [measure]>0, it works but my percentage column is not getting calculated correctly. It calulates for invidual columns and sums up instead of calculating % for the sum of the columns. I have tried giving solve order. It works only at the summary footer. The data source is OLAP. Would appreciate some help on this.
R