csimon
Occasional Member - Level 3

How do I tell Cognos Query or Report Studio to not aggregate line item details in Invoice

Hello, I am trying to figure how to tell Cognos Query or Report Studio not to aggregate values within line item details. For example, I have an Invoice Details report that provides all of the details within the request, including each allocation line and each of its properties. For like values - like GL account - it will summarize the values of that line instead of adding a separate line. I thought there was a way to do that at least in Report Studio but I can't figure it out.

So if account 740000 has two separate lines it will summarize that value - I want to break it out so that there is a line for each allocation line from the invoice. We have some transactions where 740000 would have a negative value and then another positive value - I want to have that broken out and not totalled.

I hope all that makes sense!