Filtered data table

[hobanwashburne]

I have a data set consisting of Order Type, Order Number, Release, Customer Name, Part Number, Quantity, and Requested Ship Date. The possible values for Order Type are A, B, and C. I want to create a table that only shows the data for order type B and I do not need to calculate anything - Just display the relevant data.

[ashfaq_haseeb]

Hi,

Try below

Load

[Order Type],

[Order Number],

Release,

[Customer Name],

[Part Number],

Quantity;

sql select * From table

where [Order Type] ='B'

Regards

ASHFAQ

[hobanwashburne]

I need the complete data set for other charts, but for one specific table I only want to display a specific order type.

[Anonymous]

you probably are referring to set analysis...something like sum({<[Order Type] = {"B"}> Quantity)...but you may want to elaborate more on your requirement and what your expected output looks like and if this output is in a chart/table, etc.

[hobanwashburne]

Please see attached

[Anonymous · Accepted solution]

see attached and modify as needed.