Conditional Sorting of a CrossTab

[ClanLabCooker]

Version: 8.5
Data Source: Access View with Read Only access

A text field contains, somewhere in the string, "Municipal", "District", or "Federal" (without the quotes). This field is the record specifier in the Rows entry of a CrossTab.

Question:
How do I group all the records, in alphabetical order, that contain the word "Municipal"? A second and third section of the crosstab would contain the other two key words.

 

[lbass]

Create a formula:

if instr({table.string},"Municipal") > 0 then "Municipal" else
if instr({table.string},"District") > 0 then "District" else
if instr({table.string},"Federal") > 0 then "Federal" else "Other"

Then use this formula as a second row field.

-LB