Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
see attached and modify as needed.
Hi,
Try below
Load
[Order Type],
[Order Number],
Release,
[Customer Name],
[Part Number],
Quantity;
sql select * From table
where [Order Type] ='B'
Regards
ASHFAQ
I need the complete data set for other charts, but for one specific table I only want to display a specific order type.
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.
Please see attached
see attached and modify as needed.