Transaction Search Displaying Tax Line Department and Main Line Department

1. Navigate to Reports> New Search> select Transaction> then click on  Create Saved Search button.
2. On the Criteria tab add the following Filter and Description:
    a. Standard sub tab:
        Filter | Description
        >> Posting | set to Yes
        >> Date | set any date range preferred
    b. Summary sub tab:
       Summary Type  = Maximum
       Field =  Formula (Text)
       Formula = DECODE({taxline}, 'T',{department})
                         Formula (Text) = is not empty
                         Click Set
3. On the Results sub tab add the following Field and Summary Type:
    Field | Summary Type
    >> Internal ID | Group
    >> Number | Group
    >> Main Line Name | Group
    >> Formula (Text) | Maximum | Formula = DECODE({taxline}, 'T',{department}) **Summary Label = Tax Line Department
    >> Formula (Text) | Maximum | Formula = DECODE({linesequencenumber}, 0, {department}) ** Summary Label = Main Line Department
    >> Formula (Currency) | Sum | Formula = DECODE({linesequencenumber}, 0, {amount}) **Summary Label = Transaction Amount
4. Click Save and Run  button