Display only certain rows in a Straight Table

[#1]

Hi All,

I have a straight table that displays forecast data for a large number of products. I want to create a separate table, based of the same data set that shows only certain rows from the data set. See table 1 attached, as an example of my  current table. I want my additional table to look like the table shown in the second attachment. my question is (and it's probably very basic): How can I create the second table so that it shows only the Tech  rows?

Alternatively, and this would be my  preference, is there any way to structure the first table to always show the Tech level products occupying the top rows of the table (attachment Table 3). unfortunately, the Tech data is not a total of the other items in the table so I couldn't work our a way to lift these items to the top of the table. One unique feature of the TEch data is that the part number field will always be zero.

Any help appreciated

Thanks,

John

[Anonymous]

There are no attachments (?)

[#3]

Odd I did attach... let me try again....

[Clever_Anjos]

Add a set analysis to all expressions, filtering only Tech*

something like

sum({>[Part Name]={"TEch*"}>}yourfield)

[Anonymous]

There are now...

OK, to show only "Tech", you can use calculated dimension:

aggr(only({<PartName={'Tech*'}>} PartName),PartName)

Make sure to check "suppress when null".

To keep all and have Tech on top - try to sort by expression, like this:

dual(PartName, if(wildmatch(PartName, 'Tech*'), 0, 100000)) + subfield(PartName,' ',2)

Edit: attaching a sorting example.

[#6]

You can use set analysis:

table 1 with only the tech, use a set that will use the search string capability:

sum({< [Part Name] = {"tech*"}>}, [Your data])

And to get the table without the 4 four lines of tech, that is quite the same (just a minus before the equal sign) :

sum({< [Part Name] -= {"tech*"}>}, [Your data])

Fabrice