Changes

Rolling Totals report

1,409 bytes added, 03:45, 2 January 2016

→‎Rolling Totals Settings

[[File:rollingtotals_report_001Rollingtotals_report_001.png|800px]]  

= Levels =

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

|-

DublinRed 0 0 0 2 0Blue 0 0 0 1 0North PoleRed 0 0 0 0 0Blue 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 !.

{! | class="wikitable"! ! ! '''Jan '''! '''Feb '''! '''Mar '''! '''Apr '''! '''May'''|-| '''Dublin''' || || || || || || |-| || Red || 0 || 0 || 0 || 2 || 0|-| || Blue || 0 || 0 || 0 || 1 || 0|-| || || '''0 ''' || '''0 ''' || '''0 ''' || '''3 ''' || '''0'''|-| '''North Pole''' || || || || || || |-| || Red || 0 || 0 || 0 || 0 || 0|-| || Blue || 0 || 0 || 0 || 1 || 0|-| || || '''0 ''' || '''0 ''' || '''0 ''' || '''1 ''' || '''0'''|-|}

{! | class="wikitable"! ! ! '''Jan '''! '''Feb '''! '''Mar '''! '''Apr '''! '''May'''|-| '''Dublin''' || || || || || || |-| || Red || 0 || 0 || 0 || 2 || 0|- style="border-bottom:solid 3px black;"| || Blue || 0 || 0 || 0 || 1 || 0|-| || || '''0 ''' || '''0 ''' || '''0 ''' || '''3 ''' || '''0'''|-| '''North Pole''' || || || || || || |-| || Red || 0 || 0 || 0 || 0 || 0|- style="border-bottom:solid 3px black;"| || Blue || 0 || 0 || 0 || 1 || 0|- | || || '''0 ''' || '''0 ''' || '''0 ''' || '''1 ''' || '''0'''|-|}

{! | class="wikitable"! ! ! '''Jan '''! '''Feb '''! '''Mar '''! '''Apr '''! '''May'''|-| Dublin || Red || 0 || 0 || 0 || 2 || 0|-| Dublin || Blue || 0 || 0 || 0 || 1 || 0|-| North Pole || Red || 0 || 0 || 0 || 0 || 0|-| North Pole || Blue || 0 || 0 || 0 || 1 || 0|-|} 

 {! | class="wikitable"! ! ! '''Jan '''! '''Feb '''! '''Mar '''! '''Apr '''! '''May'''|-| '''Dublin''' || || || || || || |-| || Red || 0 || 0 || 0 || 2 || 0|-| || Blue || 0 || 0 || 0 || 1 || 0|-| '''Dublin ''' || || '''0 ''' || '''0 ''' || '''0 ''' || '''3 ''' || '''0'''|-| '''North Pole''' || || || || || || |-| || Red || 0 || 0 || 0 || 0 || 0|-| || Blue || 0 || 0 || 0 || 1 || 0|-| '''North Pole ''' || || '''0 ''' || '''0 ''' || '''0 ''' || '''1 ''' || '''0'''|-|} 

• ← Older edit

Philip Lacey

Anonymous, bureaucrat, administrator

7,528

edits