Accumulation

[raviityou]

Hi All,

I am facing an issue to accumulation of Vendor count I am using calculated dimension for range and I have count of it based on that.

I am using the =RangeSum (Above( Count(DISTINCT (Vendor)),0,RowNo())) but it not working its showing the same result as it counting of vendor.

Please find the Screen shot of it.

Thanks …..!@

101

[swuehl · Accepted solution]

Are you using two dimensions? Then you may need to use the TOTAL qualifier, like

RangeSum (Above(TOTAL Count(DISTINCT (Vendor)),0,RowNo(TOTAL)))