Using Client Lookups for Custom Date Ranges

This feature utilizes lookups  which you can read about here: https://qvinci.zendesk.com/hc/en-us/articles/115001999683-Lookups-Insert-Default-and-Custom-Data-in-Reports-and-Documents

1) Set up the Lookup

1. Under Account Lookups,  create new lookup
2. Name lookup by the month then year in this convention:  Mmm YYYY ex: Oct 2017
3. Make Default in this convention:  Mmm YYYY ex: Oct 2017
4. (create as many as needed)

2) Bring lookup into report
     1. In report - where a column header will go - go to column chooser in black navigation bar              above report ​
     2.Under 'Select Frequency', select 'Use Custom Date Range'
     3. Click the bubble next to 'From Lookup Macros'
     4. Select date range
     5. Repeat in each column as needed it will look something like this: %%col|{{Oct 2017}}&{{Oct 2017}}|by Month%%