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,
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
Add comment