Combining Rows With A Total Count

[pnn44794]

Hello:

I have a situation where I need to combine rows

Some additional info.  Not all rows have the same Order Date, so the oldest Order Date should be used / returned.  Outstanding Units count, I believe, needs to be a calculated dimension so I can place it within the straight table where the users expect it.  Host Name should be what's counted as it's guaranteed to have a value.

As always, thanks in advance for any and all help and responses.

[tamilarasu · Accepted solution]

Hi Perry,

Have a look at the attached file.

[pnn44794]

Hello Tamil:

Thank you for your response.  I can see that your solution absolutely works with what I supplied you.  Unfortunately, I think I may have made a mistake.  There are a whole bunch of other columns in the dataset, but I have simply hid them.  I will dig deeper into that tomorrow and respond back.  My apologies.

[tamilarasu]

Perry - No worries. If it is not working for other columns kindly let me know. Take your time.

[pnn44794]

Hello Tamil:

My apologies for the delay in replying.  Your solution does indeed work, so I will mark it as the correct answer.  I do still have a problem though and I will be starting a new discussion and supplying more information.  It will be similar, but with more information and data supplied by me.  Thank you again for your help.