Anonymous, bureaucrat, administrator
7,528
edits
Changes
no edit summary
If we add a second level using the field colour then we get
{! | class="wikitable" {! class="wikitable"! Location! '''Jan'''! '''Feb'''! '''Mar'''! '''Apr'''! '''May'''
|-
| Dublin|| || || || || || |-| || Red || 0 || 0 || 0 || 2 || 0|-| || Blue || 0 || 0 || 0 || 1 || 0|-| North Pole || || || || || || |-| || Red || 0 || 0 || 0 || 0 || 0|-| || Blue || 0 || 0 || 0 || 1 || 0|-|}
If we wanted our report to ONLY include Dublin we could then add a Filter word. The filter word is a like match, not an exact match. So using Dublin would also match “Co. Dublin”, “Dublin 1”, etc. If we need to have an exact match put an ! before the word and system will perform an exact match and remove the !.