Skip to Content
avatar image
Former Member

Avoid row aggregation for -1 and 1 quantity

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,

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Apr 24, 2017 at 09:22 AM

    make you measure object to Dimension object and without sum aggregation.After that you will get two rows.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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

  • avatar image
    Former Member
    Apr 24, 2017 at 11:16 AM

    Here are the exemples:

    Add comment
    10|10000 characters needed characters exceeded