Help: Pivot Query or alternative way to display data

Question

Help: Pivot Query or alternative way to display data

GaffneyJ

SSC Eights!

Points: 856
More actions
October 18, 2018 at 8:52 am

#366027

Hello,
Possibly I'm missing something simple here but is there a way to display the data like below.
I think I need to do this via a Pivot but It doesn't have an aggregation or possibly an inner join. Hope you can help.
How my Data Currently Looks
Customer Method of Delivery
Test MethodA
Test MethodB
Test2 MethodB
How I would like it to look
Customer   MethodA Method B
Test MethodA MethodB
Test2 NULL MethodB

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

sgmunson SSC Guru Points: 110640 More actions · Answer 1

One easy way is to use SSRS and a matrix where Customer is the row group and the Method of Delivery is the column group. That would create a pivot and you wouldn't need to change your query.

Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)

GaffneyJ SSC Eights! Points: 856 More actions · Answer 2

Thanks,
Your idea inspired me and I manged to Create this in Power BI. Basically the same as you said. Thanks again.

Create a Matrix
Row = Customer
Column = Method Of Delivery
Values = Count on Distinct Method of Delivery