Hi all,
I have a report that lists rows from invoices. The pb is that my report aggregates the lines with "-1" and "1". So instead of 2 rows with -1 and 1 for quantity, I have one row with 0. How can I solve this? With "avoid duplicate rows aggregations" it will avoid aggregation for all rows, so it's not an option. Thank you in advance,
make you measure object to Dimension object and without sum aggregation.After that you will get two rows.
Hi Amit,
But if I use a dimension, the output would be the same as activating "Avoid duplicate row aggregation", wouldn't it? What we need is: for rows with -1 and 1 for quantity, we need the grain level, while for the others, we need the aggregation. I'll try to attach a print screen with the desired output vs. the
Output with Avoid duplicate row aggregation activated/dimension object instead of measure. Many thanks
Here are the exemples:
After converting to dimension object then in webi query properties untick the check box "retrieve duplicate rows" and refresh.