Aggr only displaying in one row on a pivot table

[#1]

I have a pivot table which i'm using
only(aggr((sum(Invoiced) + SUM(Open-Opend)),Style))

However, i have 6 rows returned then a partial sum row. And this code above only displays on one row when it should display on all 6. Any suggestions?

[johnw]

I'm thinking the only() means you'll only get a value if there's only a single Style associated with the row. Rows corresponding to multiple Styles wouldn't have a value, so there's one reason you'd only see it on one row.

You may need to post an example of the problem, as it's hard to make sense of "it should display on all 6" when I have no idea what your 6 rows are, what your dimensions are, or anything else that could easily be relevant to your question.

[#3]

Does the same thing without an only. I'll see about providing a picture.

[rwunderlich]

Try adding NODISTINCT

aggr(NODISTINCT (sum(Invoiced) + SUM(Open-Opend)),Style)

-Rob

[#5]

That worked for me. Thank you.