An attribute form is descriptive information about a business attribute. For example, the attribute Customer can have the forms First Name, Last Name, Address, Email Address, and so on. A form is a descriptive category for any data that your organization saves about any of its attributes. Just as an attribute element is a distinct occurrence of an attribute, a form defines the attribute.
Attribute-to-attribute qualifications allow you to compare attributes based on the value of their attribute forms. For example, you can return data for only new customers whose First Order Date is equal to their Last Order Date.
The procedure below shows you how to create a stand-alone attribute-to-attribute qualification filter.
On the project's main page, click Create Filter. The New Filter page opens.
In the pane on the left, navigate to the first attribute whose form you want to use to filter report data.
Right-click the attribute and select Add to Filter.
If DHTML is disabled, select the attribute and click Add > to add the attribute to the Filter panel.
Click Qualify.
From the first drop-down list, select the form to use to filter the data.
Click the Attributes
icon . The Select an Object
dialog box is displayed.
Navigate to and select the second attribute to use in the comparison.
Click OK to return to the New Filter page.
From the second drop-down list, select the operator that describes how you want to filter data, such as Equals or Less Than.
In the last drop-down list, do one of the following:
Select an attribute form for the second attribute. This is the value that will be compared against the form of the first attribute.
Select New Attribute to select a different attribute for the comparison.
Click the Apply
icon to create your filtering condition.
Click Save As. The Save As dialog box opens.
Navigate to the folder where you want to save the filter. Type a Name and Description for the filter, and click OK. Your new filter is saved.
The filter that you created can now be added to a report. For steps, see Adding a stand-alone filter to a report.