Hi,
I have an object that exists as a measure and is rolling up (summing) the qtys. So when I right click on the table, and go to the General tab and enable Avoid Duplicate Rows Aggregation I get the individual qtys. The qtys are actually descending as it should be doing because this object is calculating availability, and when the qty’s rollup when Avoid Duplicate Rows Aggregation is disabled the qty is showing a wildly erratic number which is not accurate of the total availability. So what I want is to show the first number at the top of the list when Avoid Duplicate Rows Aggregation is enabled, which is the proper Availability. Is there anyway to select a certain row using =RowIndex() in an arithmetic context when the Avoid Duplicate Row Aggregation is disabled??
Thanks in advance!
Joel
JTAMBLYN (BOB member since 2003-05-28)