QV Merge Two rows in one Row

[vijayit43]

In My QV  One Order agains Multiple Item We want to create pivot where dimension field in customerid,msalesorderno,date,DO No,DO Date and Expression Field Sum(Actual Qty) and Sum(Do QTY),, We wand to Show Those Of Records show in one Row But it break in 2 rows at Do No because one Item are DO order Not Created where show blank how to solve this issue for refrence Attach QV

[mdmukramali]

Dear,

Vijay you want to hide the null rows?

can you please elaborate what you are looking for?

Thanks,

Mukram

[vijayit43]

Yes I want to hide null row but null rows quantity is sum to another rows quantity

[mdmukramali]

Dear,

then what you want to display in that null columns.

[vijayit43]

No, but that Row quantity sum in bellow line Quantity

[#6 · Accepted solution]

Please see attached. I suppressed null values on Dono field:

Then added an aggr around the expressions so that values summed over all customer records.

Hope that helps.

Matt