PIE Chart: Show data of column by considering distinct data of another column.

[harjotsingh16]

Hello,

I am facing issue in creating Pie Chart, below is the situation

1. I want to create the Pie chart that shows the Shipping type with only text in "Column A" i.e "TL", "LTL" and "Rail TL"

2. The condition along above is that I want to only show data of distinct shipment numbers from column "Shipment#"

please assist what can I do in this?

[Or]

Not really clear what the issue is from your description. It sounds like a regular chart with Shipping Type as the dimension and count(distinct Shipment#) as the measure. I'm assuming this isn't the case, though, as you probably wouldn't be asking if that was it, so perhaps you could elaborate on what the issue is?

[harjotsingh16 · Accepted solution]

I got the way !!

Was looking different thing 

Thanks though 🙂

[yp03]

Hi, can you share the way you did to show data of column by considering distinct data of another column in pie chart?