worksheet how to filter to just one layer

[grant_PD]

I'm having trouble with the syntax for a worksheet I've created. I made a report from Landru's Soft Goods tool, pulling criteria from it to make a Curtain Schedule. But it gives me all of the soft goods in the file. I want to limit it to just one layer, but don't know the syntax to do that. Take a look at my attached screen shot.

What I want to do is edit each column so that worksheet only searches in a specific layer. How do I write that?

Thanks!

[Pat Stanford]

Right click on the Row Header (Database Header row) where it say 3 (not 3.1, etc.). Select Edit Criteria.

Add a new criteria of Layer is XXXX.

Close the dialog.

You may have to Recalculate the worksheet.

[grant_PD]

In 15 years I may have never right clicked there... Thanks so much!

[Pat Stanford]

If you only have a one button mouse you can simulate a right click by holding down the CTRL key and clicking.

Try right clicking on other objects. There are a lot a context sensitive options for many objects. i.e. if you right click on a viewport you will have options to edit the crop or annotations as well as other things.