EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

KB17904: How to prompt for a month and show data for the last 12 months using warehouse transformation tables


Community Admin

• Strategy


Follow the steps below to prompt for a month and show data for the last 12 months:
 

  • Create a new warehouse transformation table that contains a listing of the last 12 months for a particular year-month combination and appears similar to the following example:
     

     
    This layer…is overwritten by these layers…metric object - headersaxis headers, grid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersmetric object - valuesaxis values, grid unit values, all metrics values, report metric values column subtotal values row subtotal valuesaxis - headersgrid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersaxis - valuesgrid unit values, all metrics values, report metric values column subtotal values row subtotal valuesgrid unit - headersall metrics headers, report metric headers, column subtotal headers, row subtotal headersgrid unit - valuesall metrics values, report metric values column subtotal values row subtotal valuesall metrics - headersreport metric headers, column subtotal headersall metrics - valuesreport metric values column subtotal valuesreport metricbanding, column subtotals, row subtotals, thresholdbandingcolumn subtotals, row subtotals, thresholdcolumn subtotalsrow subtotals, thresholdrow subtotalsthresholdreport bordernonethresholdnoneLevelWhat is it?set it here…Notesmetricspecifies a format for a metric regardless of the report it is on.set in the metric editor."all metrics" and "axis" formatting must be set at defaultaxisaffects all units of the axis.format --> rows and columnsgrid unit formatting must be set to defaultgrid unitformatting of individual report items such as attributesgrid units are listed on the Format menu all metricformats the data zone (where the metric values are displayed)format --> all metrics report metricformats an individual metric on a particular reportindividual metrics are listed in the format menu bandingrow or column grouping by colorgrid --> options column subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format -->columns -->subtotal headers or values. to set "grid unit" formatting, select the grid unit from the format menu.row subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format --> rows -->subtotal headers or values. to set "grid unit" formatting, select the ggrid unit from the format menu.overwrites column subtotal formatting where they intersect with row subtotal formattingreport bordercreates a border around the whole reportright-click on the report (but NOT a report object) then select formatting --> report borders thresholdchanges formatting based on returned data.grid --> Thresholdsoverwrites all other layers.Month_IDLast_12_Month200612200612200612200611200612200610200612200609200612200608200612200607200612200606200612200605200612200604200612200603200612200602200612200601200611200611200611200610200611200609200611200608200611200607200611200606200611200605200611200604200611200603200611200602200611200601200611200512......

     
    This layer…is overwritten by these layers…metric object - headersaxis headers, grid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersmetric object - valuesaxis values, grid unit values, all metrics values, report metric values column subtotal values row subtotal valuesaxis - headersgrid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersaxis - valuesgrid unit values, all metrics values, report metric values column subtotal values row subtotal valuesgrid unit - headersall metrics headers, report metric headers, column subtotal headers, row subtotal headersgrid unit - valuesall metrics values, report metric values column subtotal values row subtotal valuesall metrics - headersreport metric headers, column subtotal headersall metrics - valuesreport metric values column subtotal valuesreport metricbanding, column subtotals, row subtotals, thresholdbandingcolumn subtotals, row subtotals, thresholdcolumn subtotalsrow subtotals, thresholdrow subtotalsthresholdreport bordernonethresholdnoneLevelWhat is it?set it here…Notesmetricspecifies a format for a metric regardless of the report it is on.set in the metric editor."all metrics" and "axis" formatting must be set at defaultaxisaffects all units of the axis.format --> rows and columnsgrid unit formatting must be set to defaultgrid unitformatting of individual report items such as attributesgrid units are listed on the Format menu all metricformats the data zone (where the metric values are displayed)format --> all metrics report metricformats an individual metric on a particular reportindividual metrics are listed in the format menu bandingrow or column grouping by colorgrid --> options column subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format -->columns -->subtotal headers or values. to set "grid unit" formatting, select the grid unit from the format menu.row subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format --> rows -->subtotal headers or values. to set "grid unit" formatting, select the ggrid unit from the format menu.overwrites column subtotal formatting where they intersect with row subtotal formattingreport bordercreates a border around the whole reportright-click on the report (but NOT a report object) then select formatting --> report borders thresholdchanges formatting based on returned data.grid --> Thresholdsoverwrites all other layers.Month_IDLast_12_Month200612200612200612200611200612200610200612200609200612200608200612200607200612200606200612200605200612200604200612200603200612200602200612200601200611200611200611200610200611200609200611200608200611200607200611200606200611200605200611200604200611200603200611200602200611200601200611200512......

     
    This layer…is overwritten by these layers…metric object - headersaxis headers, grid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersmetric object - valuesaxis values, grid unit values, all metrics values, report metric values column subtotal values row subtotal valuesaxis - headersgrid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersaxis - valuesgrid unit values, all metrics values, report metric values column subtotal values row subtotal valuesgrid unit - headersall metrics headers, report metric headers, column subtotal headers, row subtotal headersgrid unit - valuesall metrics values, report metric values column subtotal values row subtotal valuesall metrics - headersreport metric headers, column subtotal headersall metrics - valuesreport metric values column subtotal valuesreport metricbanding, column subtotals, row subtotals, thresholdbandingcolumn subtotals, row subtotals, thresholdcolumn subtotalsrow subtotals, thresholdrow subtotalsthresholdreport bordernonethresholdnoneLevelWhat is it?set it here…Notesmetricspecifies a format for a metric regardless of the report it is on.set in the metric editor."all metrics" and "axis" formatting must be set at defaultaxisaffects all units of the axis.format --> rows and columnsgrid unit formatting must be set to defaultgrid unitformatting of individual report items such as attributesgrid units are listed on the Format menu all metricformats the data zone (where the metric values are displayed)format --> all metrics report metricformats an individual metric on a particular reportindividual metrics are listed in the format menu bandingrow or column grouping by colorgrid --> options column subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format -->columns -->subtotal headers or values. to set "grid unit" formatting, select the grid unit from the format menu.row subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format --> rows -->subtotal headers or values. to set "grid unit" formatting, select the ggrid unit from the format menu.overwrites column subtotal formatting where they intersect with row subtotal formattingreport bordercreates a border around the whole reportright-click on the report (but NOT a report object) then select formatting --> report borders thresholdchanges formatting based on returned data.grid --> Thresholdsoverwrites all other layers.Month_IDLast_12_Month200612200612200612200611200612200610200612200609200612200608200612200607200612200606200612200605200612200604200612200603200612200602200612200601200611200611200611200610200611200609200611200608200611200607200611200606200611200605200611200604200611200603200611200602200611200601200611200512......

     
    This layer…is overwritten by these layers…metric object - headersaxis headers, grid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersmetric object - valuesaxis values, grid unit values, all metrics values, report metric values column subtotal values row subtotal valuesaxis - headersgrid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersaxis - valuesgrid unit values, all metrics values, report metric values column subtotal values row subtotal valuesgrid unit - headersall metrics headers, report metric headers, column subtotal headers, row subtotal headersgrid unit - valuesall metrics values, report metric values column subtotal values row subtotal valuesall metrics - headersreport metric headers, column subtotal headersall metrics - valuesreport metric values column subtotal valuesreport metricbanding, column subtotals, row subtotals, thresholdbandingcolumn subtotals, row subtotals, thresholdcolumn subtotalsrow subtotals, thresholdrow subtotalsthresholdreport bordernonethresholdnoneLevelWhat is it?set it here…Notesmetricspecifies a format for a metric regardless of the report it is on.set in the metric editor."all metrics" and "axis" formatting must be set at defaultaxisaffects all units of the axis.format --> rows and columnsgrid unit formatting must be set to defaultgrid unitformatting of individual report items such as attributesgrid units are listed on the Format menu all metricformats the data zone (where the metric values are displayed)format --> all metrics report metricformats an individual metric on a particular reportindividual metrics are listed in the format menu bandingrow or column grouping by colorgrid --> options column subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format -->columns -->subtotal headers or values. to set "grid unit" formatting, select the grid unit from the format menu.row subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format --> rows -->subtotal headers or values. to set "grid unit" formatting, select the ggrid unit from the format menu.overwrites column subtotal formatting where they intersect with row subtotal formattingreport bordercreates a border around the whole reportright-click on the report (but NOT a report object) then select formatting --> report borders thresholdchanges formatting based on returned data.grid --> Thresholdsoverwrites all other layers.Month_IDLast_12_Month200612200612200612200611200612200610200612200609200612200608200612200607200612200606200612200605200612200604200612200603200612200602200612200601200611200611200611200610200611200609200611200608200611200607200611200606200611200605200611200604200611200603200611200602200611200601200611200512......

     
    This layer…is overwritten by these layers…metric object - headersaxis headers, grid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersmetric object - valuesaxis values, grid unit values, all metrics values, report metric values column subtotal values row subtotal valuesaxis - headersgrid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersaxis - valuesgrid unit values, all metrics values, report metric values column subtotal values row subtotal valuesgrid unit - headersall metrics headers, report metric headers, column subtotal headers, row subtotal headersgrid unit - valuesall metrics values, report metric values column subtotal values row subtotal valuesall metrics - headersreport metric headers, column subtotal headersall metrics - valuesreport metric values column subtotal valuesreport metricbanding, column subtotals, row subtotals, thresholdbandingcolumn subtotals, row subtotals, thresholdcolumn subtotalsrow subtotals, thresholdrow subtotalsthresholdreport bordernonethresholdnoneLevelWhat is it?set it here…Notesmetricspecifies a format for a metric regardless of the report it is on.set in the metric editor."all metrics" and "axis" formatting must be set at defaultaxisaffects all units of the axis.format --> rows and columnsgrid unit formatting must be set to defaultgrid unitformatting of individual report items such as attributesgrid units are listed on the Format menu all metricformats the data zone (where the metric values are displayed)format --> all metrics report metricformats an individual metric on a particular reportindividual metrics are listed in the format menu bandingrow or column grouping by colorgrid --> options column subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format -->columns -->subtotal headers or values. to set "grid unit" formatting, select the grid unit from the format menu.row subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format --> rows -->subtotal headers or values. to set "grid unit" formatting, select the ggrid unit from the format menu.overwrites column subtotal formatting where they intersect with row subtotal formattingreport bordercreates a border around the whole reportright-click on the report (but NOT a report object) then select formatting --> report borders thresholdchanges formatting based on returned data.grid --> Thresholdsoverwrites all other layers.Month_IDLast_12_Month200612200612200612200611200612200610200612200609200612200608200612200607200612200606200612200605200612200604200612200603200612200602200612200601200611200611200611200610200611200609200611200608200611200607200611200606200611200605200611200604200611200603200611200602200611200601200611200512......

     
    This layer…is overwritten by these layers…metric object - headersaxis headers, grid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersmetric object - valuesaxis values, grid unit values, all metrics values, report metric values column subtotal values row subtotal valuesaxis - headersgrid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersaxis - valuesgrid unit values, all metrics values, report metric values column subtotal values row subtotal valuesgrid unit - headersall metrics headers, report metric headers, column subtotal headers, row subtotal headersgrid unit - valuesall metrics values, report metric values column subtotal values row subtotal valuesall metrics - headersreport metric headers, column subtotal headersall metrics - valuesreport metric values column subtotal valuesreport metricbanding, column subtotals, row subtotals, thresholdbandingcolumn subtotals, row subtotals, thresholdcolumn subtotalsrow subtotals, thresholdrow subtotalsthresholdreport bordernonethresholdnoneLevelWhat is it?set it here…Notesmetricspecifies a format for a metric regardless of the report it is on.set in the metric editor."all metrics" and "axis" formatting must be set at defaultaxisaffects all units of the axis.format --> rows and columnsgrid unit formatting must be set to defaultgrid unitformatting of individual report items such as attributesgrid units are listed on the Format menu all metricformats the data zone (where the metric values are displayed)format --> all metrics report metricformats an individual metric on a particular reportindividual metrics are listed in the format menu bandingrow or column grouping by colorgrid --> options column subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format -->columns -->subtotal headers or values. to set "grid unit" formatting, select the grid unit from the format menu.row subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format --> rows -->subtotal headers or values. to set "grid unit" formatting, select the ggrid unit from the format menu.overwrites column subtotal formatting where they intersect with row subtotal formattingreport bordercreates a border around the whole reportright-click on the report (but NOT a report object) then select formatting --> report borders thresholdchanges formatting based on returned data.grid --> Thresholdsoverwrites all other layers.Month_IDLast_12_Month200612200612200612200611200612200610200612200609200612200608200612200607200612200606200612200605200612200604200612200603200612200602200612200601200611200611200611200610200611200609200611200608200611200607200611200606200611200605200611200604200611200603200611200602200611200601200611200512......

     
    This layer…is overwritten by these layers…metric object - headersaxis headers, grid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersmetric object - valuesaxis values, grid unit values, all metrics values, report metric values column subtotal values row subtotal valuesaxis - headersgrid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersaxis - valuesgrid unit values, all metrics values, report metric values column subtotal values row subtotal valuesgrid unit - headersall metrics headers, report metric headers, column subtotal headers, row subtotal headersgrid unit - valuesall metrics values, report metric values column subtotal values row subtotal valuesall metrics - headersreport metric headers, column subtotal headersall metrics - valuesreport metric values column subtotal valuesreport metricbanding, column subtotals, row subtotals, thresholdbandingcolumn subtotals, row subtotals, thresholdcolumn subtotalsrow subtotals, thresholdrow subtotalsthresholdreport bordernonethresholdnoneLevelWhat is it?set it here…Notesmetricspecifies a format for a metric regardless of the report it is on.set in the metric editor."all metrics" and "axis" formatting must be set at defaultaxisaffects all units of the axis.format --> rows and columnsgrid unit formatting must be set to defaultgrid unitformatting of individual report items such as attributesgrid units are listed on the Format menu all metricformats the data zone (where the metric values are displayed)format --> all metrics report metricformats an individual metric on a particular reportindividual metrics are listed in the format menu bandingrow or column grouping by colorgrid --> options column subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format -->columns -->subtotal headers or values. to set "grid unit" formatting, select the grid unit from the format menu.row subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format --> rows -->subtotal headers or values. to set "grid unit" formatting, select the ggrid unit from the format menu.overwrites column subtotal formatting where they intersect with row subtotal formattingreport bordercreates a border around the whole reportright-click on the report (but NOT a report object) then select formatting --> report borders thresholdchanges formatting based on returned data.grid --> Thresholdsoverwrites all other layers.Month_IDLast_12_Month200612200612200612200611200612200610200612200609200612200608200612200607200612200606200612200605200612200604200612200603200612200602200612200601200611200611200611200610200611200609200611200608200611200607200611200606200611200605200611200604200611200603200611200602200611200601200611200512......

     
    This layer…is overwritten by these layers…metric object - headersaxis headers, grid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersmetric object - valuesaxis values, grid unit values, all metrics values, report metric values column subtotal values row subtotal valuesaxis - headersgrid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersaxis - valuesgrid unit values, all metrics values, report metric values column subtotal values row subtotal valuesgrid unit - headersall metrics headers, report metric headers, column subtotal headers, row subtotal headersgrid unit - valuesall metrics values, report metric values column subtotal values row subtotal valuesall metrics - headersreport metric headers, column subtotal headersall metrics - valuesreport metric values column subtotal valuesreport metricbanding, column subtotals, row subtotals, thresholdbandingcolumn subtotals, row subtotals, thresholdcolumn subtotalsrow subtotals, thresholdrow subtotalsthresholdreport bordernonethresholdnoneLevelWhat is it?set it here…Notesmetricspecifies a format for a metric regardless of the report it is on.set in the metric editor."all metrics" and "axis" formatting must be set at defaultaxisaffects all units of the axis.format --> rows and columnsgrid unit formatting must be set to defaultgrid unitformatting of individual report items such as attributesgrid units are listed on the Format menu all metricformats the data zone (where the metric values are displayed)format --> all metrics report metricformats an individual metric on a particular reportindividual metrics are listed in the format menu bandingrow or column grouping by colorgrid --> options column subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format -->columns -->subtotal headers or values. to set "grid unit" formatting, select the grid unit from the format menu.row subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format --> rows -->subtotal headers or values. to set "grid unit" formatting, select the ggrid unit from the format menu.overwrites column subtotal formatting where they intersect with row subtotal formattingreport bordercreates a border around the whole reportright-click on the report (but NOT a report object) then select formatting --> report borders thresholdchanges formatting based on returned data.grid --> Thresholdsoverwrites all other layers.Month_IDLast_12_Month200612200612200612200611200612200610200612200609200612200608200612200607200612200606200612200605200612200604200612200603200612200602200612200601200611200611200611200610200611200609200611200608200611200607200611200606200611200605200611200604200611200603200611200602200611200601200611200512......

     
    This layer…is overwritten by these layers…metric object - headersaxis headers, grid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersmetric object - valuesaxis values, grid unit values, all metrics values, report metric values column subtotal values row subtotal valuesaxis - headersgrid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersaxis - valuesgrid unit values, all metrics values, report metric values column subtotal values row subtotal valuesgrid unit - headersall metrics headers, report metric headers, column subtotal headers, row subtotal headersgrid unit - valuesall metrics values, report metric values column subtotal values row subtotal valuesall metrics - headersreport metric headers, column subtotal headersall metrics - valuesreport metric values column subtotal valuesreport metricbanding, column subtotals, row subtotals, thresholdbandingcolumn subtotals, row subtotals, thresholdcolumn subtotalsrow subtotals, thresholdrow subtotalsthresholdreport bordernonethresholdnoneLevelWhat is it?set it here…Notesmetricspecifies a format for a metric regardless of the report it is on.set in the metric editor."all metrics" and "axis" formatting must be set at defaultaxisaffects all units of the axis.format --> rows and columnsgrid unit formatting must be set to defaultgrid unitformatting of individual report items such as attributesgrid units are listed on the Format menu all metricformats the data zone (where the metric values are displayed)format --> all metrics report metricformats an individual metric on a particular reportindividual metrics are listed in the format menu bandingrow or column grouping by colorgrid --> options column subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format -->columns -->subtotal headers or values. to set "grid unit" formatting, select the grid unit from the format menu.row subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format --> rows -->subtotal headers or values. to set "grid unit" formatting, select the ggrid unit from the format menu.overwrites column subtotal formatting where they intersect with row subtotal formattingreport bordercreates a border around the whole reportright-click on the report (but NOT a report object) then select formatting --> report borders thresholdchanges formatting based on returned data.grid --> Thresholdsoverwrites all other layers.Month_IDLast_12_Month200612200612200612200611200612200610200612200609200612200608200612200607200612200606200612200605200612200604200612200603200612200602200612200601200611200611200611200610200611200609200611200608200611200607200611200606200611200605200611200604200611200603200611200602200611200601200611200512......

     
    This layer…is overwritten by these layers…metric object - headersaxis headers, grid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersmetric object - valuesaxis values, grid unit values, all metrics values, report metric values column subtotal values row subtotal valuesaxis - headersgrid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersaxis - valuesgrid unit values, all metrics values, report metric values column subtotal values row subtotal valuesgrid unit - headersall metrics headers, report metric headers, column subtotal headers, row subtotal headersgrid unit - valuesall metrics values, report metric values column subtotal values row subtotal valuesall metrics - headersreport metric headers, column subtotal headersall metrics - valuesreport metric values column subtotal valuesreport metricbanding, column subtotals, row subtotals, thresholdbandingcolumn subtotals, row subtotals, thresholdcolumn subtotalsrow subtotals, thresholdrow subtotalsthresholdreport bordernonethresholdnoneLevelWhat is it?set it here…Notesmetricspecifies a format for a metric regardless of the report it is on.set in the metric editor."all metrics" and "axis" formatting must be set at defaultaxisaffects all units of the axis.format --> rows and columnsgrid unit formatting must be set to defaultgrid unitformatting of individual report items such as attributesgrid units are listed on the Format menu all metricformats the data zone (where the metric values are displayed)format --> all metrics report metricformats an individual metric on a particular reportindividual metrics are listed in the format menu bandingrow or column grouping by colorgrid --> options column subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format -->columns -->subtotal headers or values. to set "grid unit" formatting, select the grid unit from the format menu.row subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format --> rows -->subtotal headers or values. to set "grid unit" formatting, select the ggrid unit from the format menu.overwrites column subtotal formatting where they intersect with row subtotal formattingreport bordercreates a border around the whole reportright-click on the report (but NOT a report object) then select formatting --> report borders thresholdchanges formatting based on returned data.grid --> Thresholdsoverwrites all other layers.Month_IDLast_12_Month200612200612200612200611200612200610200612200609200612200608200612200607200612200606200612200605200612200604200612200603200612200602200612200601200611200611200611200610200611200609200611200608200611200607200611200606200611200605200611200604200611200603200611200602200611200601200611200512......

     
    This layer…is overwritten by these layers…metric object - headersaxis headers, grid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersmetric object - valuesaxis values, grid unit values, all metrics values, report metric values column subtotal values row subtotal valuesaxis - headersgrid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersaxis - valuesgrid unit values, all metrics values, report metric values column subtotal values row subtotal valuesgrid unit - headersall metrics headers, report metric headers, column subtotal headers, row subtotal headersgrid unit - valuesall metrics values, report metric values column subtotal values row subtotal valuesall metrics - headersreport metric headers, column subtotal headersall metrics - valuesreport metric values column subtotal valuesreport metricbanding, column subtotals, row subtotals, thresholdbandingcolumn subtotals, row subtotals, thresholdcolumn subtotalsrow subtotals, thresholdrow subtotalsthresholdreport bordernonethresholdnoneLevelWhat is it?set it here…Notesmetricspecifies a format for a metric regardless of the report it is on.set in the metric editor."all metrics" and "axis" formatting must be set at defaultaxisaffects all units of the axis.format --> rows and columnsgrid unit formatting must be set to defaultgrid unitformatting of individual report items such as attributesgrid units are listed on the Format menu all metricformats the data zone (where the metric values are displayed)format --> all metrics report metricformats an individual metric on a particular reportindividual metrics are listed in the format menu bandingrow or column grouping by colorgrid --> options column subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format -->columns -->subtotal headers or values. to set "grid unit" formatting, select the grid unit from the format menu.row subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format --> rows -->subtotal headers or values. to set "grid unit" formatting, select the ggrid unit from the format menu.overwrites column subtotal formatting where they intersect with row subtotal formattingreport bordercreates a border around the whole reportright-click on the report (but NOT a report object) then select formatting --> report borders thresholdchanges formatting based on returned data.grid --> Thresholdsoverwrites all other layers.Month_IDLast_12_Month200612200612200612200611200612200610200612200609200612200608200612200607200612200606200612200605200612200604200612200603200612200602200612200601200611200611200611200610200611200609200611200608200611200607200611200606200611200605200611200604200611200603200611200602200611200601200611200512......

     
    This layer…is overwritten by these layers…metric object - headersaxis headers, grid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersmetric object - valuesaxis values, grid unit values, all metrics values, report metric values column subtotal values row subtotal valuesaxis - headersgrid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersaxis - valuesgrid unit values, all metrics values, report metric values column subtotal values row subtotal valuesgrid unit - headersall metrics headers, report metric headers, column subtotal headers, row subtotal headersgrid unit - valuesall metrics values, report metric values column subtotal values row subtotal valuesall metrics - headersreport metric headers, column subtotal headersall metrics - valuesreport metric values column subtotal valuesreport metricbanding, column subtotals, row subtotals, thresholdbandingcolumn subtotals, row subtotals, thresholdcolumn subtotalsrow subtotals, thresholdrow subtotalsthresholdreport bordernonethresholdnoneLevelWhat is it?set it here…Notesmetricspecifies a format for a metric regardless of the report it is on.set in the metric editor."all metrics" and "axis" formatting must be set at defaultaxisaffects all units of the axis.format --> rows and columnsgrid unit formatting must be set to defaultgrid unitformatting of individual report items such as attributesgrid units are listed on the Format menu all metricformats the data zone (where the metric values are displayed)format --> all metrics report metricformats an individual metric on a particular reportindividual metrics are listed in the format menu bandingrow or column grouping by colorgrid --> options column subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format -->columns -->subtotal headers or values. to set "grid unit" formatting, select the grid unit from the format menu.row subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format --> rows -->subtotal headers or values. to set "grid unit" formatting, select the ggrid unit from the format menu.overwrites column subtotal formatting where they intersect with row subtotal formattingreport bordercreates a border around the whole reportright-click on the report (but NOT a report object) then select formatting --> report borders thresholdchanges formatting based on returned data.grid --> Thresholdsoverwrites all other layers.Month_IDLast_12_Month200612200612200612200611200612200610200612200609200612200608200612200607200612200606200612200605200612200604200612200603200612200602200612200601200611200611200611200610200611200609200611200608200611200607200611200606200611200605200611200604200611200603200611200602200611200601200611200512......

     
    This layer…is overwritten by these layers…metric object - headersaxis headers, grid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersmetric object - valuesaxis values, grid unit values, all metrics values, report metric values column subtotal values row subtotal valuesaxis - headersgrid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersaxis - valuesgrid unit values, all metrics values, report metric values column subtotal values row subtotal valuesgrid unit - headersall metrics headers, report metric headers, column subtotal headers, row subtotal headersgrid unit - valuesall metrics values, report metric values column subtotal values row subtotal valuesall metrics - headersreport metric headers, column subtotal headersall metrics - valuesreport metric values column subtotal valuesreport metricbanding, column subtotals, row subtotals, thresholdbandingcolumn subtotals, row subtotals, thresholdcolumn subtotalsrow subtotals, thresholdrow subtotalsthresholdreport bordernonethresholdnoneLevelWhat is it?set it here…Notesmetricspecifies a format for a metric regardless of the report it is on.set in the metric editor."all metrics" and "axis" formatting must be set at defaultaxisaffects all units of the axis.format --> rows and columnsgrid unit formatting must be set to defaultgrid unitformatting of individual report items such as attributesgrid units are listed on the Format menu all metricformats the data zone (where the metric values are displayed)format --> all metrics report metricformats an individual metric on a particular reportindividual metrics are listed in the format menu bandingrow or column grouping by colorgrid --> options column subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format -->columns -->subtotal headers or values. to set "grid unit" formatting, select the grid unit from the format menu.row subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format --> rows -->subtotal headers or values. to set "grid unit" formatting, select the ggrid unit from the format menu.overwrites column subtotal formatting where they intersect with row subtotal formattingreport bordercreates a border around the whole reportright-click on the report (but NOT a report object) then select formatting --> report borders thresholdchanges formatting based on returned data.grid --> Thresholdsoverwrites all other layers.Month_IDLast_12_Month200612200612200612200611200612200610200612200609200612200608200612200607200612200606200612200605200612200604200612200603200612200602200612200601200611200611200611200610200611200609200611200608200611200607200611200606200611200605200611200604200611200603200611200602200611200601200611200512......

     
    This layer…is overwritten by these layers…metric object - headersaxis headers, grid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersmetric object - valuesaxis values, grid unit values, all metrics values, report metric values column subtotal values row subtotal valuesaxis - headersgrid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersaxis - valuesgrid unit values, all metrics values, report metric values column subtotal values row subtotal valuesgrid unit - headersall metrics headers, report metric headers, column subtotal headers, row subtotal headersgrid unit - valuesall metrics values, report metric values column subtotal values row subtotal valuesall metrics - headersreport metric headers, column subtotal headersall metrics - valuesreport metric values column subtotal valuesreport metricbanding, column subtotals, row subtotals, thresholdbandingcolumn subtotals, row subtotals, thresholdcolumn subtotalsrow subtotals, thresholdrow subtotalsthresholdreport bordernonethresholdnoneLevelWhat is it?set it here…Notesmetricspecifies a format for a metric regardless of the report it is on.set in the metric editor."all metrics" and "axis" formatting must be set at defaultaxisaffects all units of the axis.format --> rows and columnsgrid unit formatting must be set to defaultgrid unitformatting of individual report items such as attributesgrid units are listed on the Format menu all metricformats the data zone (where the metric values are displayed)format --> all metrics report metricformats an individual metric on a particular reportindividual metrics are listed in the format menu bandingrow or column grouping by colorgrid --> options column subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format -->columns -->subtotal headers or values. to set "grid unit" formatting, select the grid unit from the format menu.row subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format --> rows -->subtotal headers or values. to set "grid unit" formatting, select the ggrid unit from the format menu.overwrites column subtotal formatting where they intersect with row subtotal formattingreport bordercreates a border around the whole reportright-click on the report (but NOT a report object) then select formatting --> report borders thresholdchanges formatting based on returned data.grid --> Thresholdsoverwrites all other layers.Month_IDLast_12_Month200612200612200612200611200612200610200612200609200612200608200612200607200612200606200612200605200612200604200612200603200612200602200612200601200611200611200611200610200611200609200611200608200611200607200611200606200611200605200611200604200611200603200611200602200611200601200611200512......

     
    This layer…is overwritten by these layers…metric object - headersaxis headers, grid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersmetric object - valuesaxis values, grid unit values, all metrics values, report metric values column subtotal values row subtotal valuesaxis - headersgrid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersaxis - valuesgrid unit values, all metrics values, report metric values column subtotal values row subtotal valuesgrid unit - headersall metrics headers, report metric headers, column subtotal headers, row subtotal headersgrid unit - valuesall metrics values, report metric values column subtotal values row subtotal valuesall metrics - headersreport metric headers, column subtotal headersall metrics - valuesreport metric values column subtotal valuesreport metricbanding, column subtotals, row subtotals, thresholdbandingcolumn subtotals, row subtotals, thresholdcolumn subtotalsrow subtotals, thresholdrow subtotalsthresholdreport bordernonethresholdnoneLevelWhat is it?set it here…Notesmetricspecifies a format for a metric regardless of the report it is on.set in the metric editor."all metrics" and "axis" formatting must be set at defaultaxisaffects all units of the axis.format --> rows and columnsgrid unit formatting must be set to defaultgrid unitformatting of individual report items such as attributesgrid units are listed on the Format menu all metricformats the data zone (where the metric values are displayed)format --> all metrics report metricformats an individual metric on a particular reportindividual metrics are listed in the format menu bandingrow or column grouping by colorgrid --> options column subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format -->columns -->subtotal headers or values. to set "grid unit" formatting, select the grid unit from the format menu.row subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format --> rows -->subtotal headers or values. to set "grid unit" formatting, select the ggrid unit from the format menu.overwrites column subtotal formatting where they intersect with row subtotal formattingreport bordercreates a border around the whole reportright-click on the report (but NOT a report object) then select formatting --> report borders thresholdchanges formatting based on returned data.grid --> Thresholdsoverwrites all other layers.Month_IDLast_12_Month200612200612200612200611200612200610200612200609200612200608200612200607200612200606200612200605200612200604200612200603200612200602200612200601200611200611200611200610200611200609200611200608200611200607200611200606200611200605200611200604200611200603200611200602200611200601200611200512......

     
    This layer…is overwritten by these layers…metric object - headersaxis headers, grid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersmetric object - valuesaxis values, grid unit values, all metrics values, report metric values column subtotal values row subtotal valuesaxis - headersgrid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersaxis - valuesgrid unit values, all metrics values, report metric values column subtotal values row subtotal valuesgrid unit - headersall metrics headers, report metric headers, column subtotal headers, row subtotal headersgrid unit - valuesall metrics values, report metric values column subtotal values row subtotal valuesall metrics - headersreport metric headers, column subtotal headersall metrics - valuesreport metric values column subtotal valuesreport metricbanding, column subtotals, row subtotals, thresholdbandingcolumn subtotals, row subtotals, thresholdcolumn subtotalsrow subtotals, thresholdrow subtotalsthresholdreport bordernonethresholdnoneLevelWhat is it?set it here…Notesmetricspecifies a format for a metric regardless of the report it is on.set in the metric editor."all metrics" and "axis" formatting must be set at defaultaxisaffects all units of the axis.format --> rows and columnsgrid unit formatting must be set to defaultgrid unitformatting of individual report items such as attributesgrid units are listed on the Format menu all metricformats the data zone (where the metric values are displayed)format --> all metrics report metricformats an individual metric on a particular reportindividual metrics are listed in the format menu bandingrow or column grouping by colorgrid --> options column subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format -->columns -->subtotal headers or values. to set "grid unit" formatting, select the grid unit from the format menu.row subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format --> rows -->subtotal headers or values. to set "grid unit" formatting, select the ggrid unit from the format menu.overwrites column subtotal formatting where they intersect with row subtotal formattingreport bordercreates a border around the whole reportright-click on the report (but NOT a report object) then select formatting --> report borders thresholdchanges formatting based on returned data.grid --> Thresholdsoverwrites all other layers.Month_IDLast_12_Month200612200612200612200611200612200610200612200609200612200608200612200607200612200606200612200605200612200604200612200603200612200602200612200601200611200611200611200610200611200609200611200608200611200607200611200606200611200605200611200604200611200603200611200602200611200601200611200512......

     
    This layer…is overwritten by these layers…metric object - headersaxis headers, grid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersmetric object - valuesaxis values, grid unit values, all metrics values, report metric values column subtotal values row subtotal valuesaxis - headersgrid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersaxis - valuesgrid unit values, all metrics values, report metric values column subtotal values row subtotal valuesgrid unit - headersall metrics headers, report metric headers, column subtotal headers, row subtotal headersgrid unit - valuesall metrics values, report metric values column subtotal values row subtotal valuesall metrics - headersreport metric headers, column subtotal headersall metrics - valuesreport metric values column subtotal valuesreport metricbanding, column subtotals, row subtotals, thresholdbandingcolumn subtotals, row subtotals, thresholdcolumn subtotalsrow subtotals, thresholdrow subtotalsthresholdreport bordernonethresholdnoneLevelWhat is it?set it here…Notesmetricspecifies a format for a metric regardless of the report it is on.set in the metric editor."all metrics" and "axis" formatting must be set at defaultaxisaffects all units of the axis.format --> rows and columnsgrid unit formatting must be set to defaultgrid unitformatting of individual report items such as attributesgrid units are listed on the Format menu all metricformats the data zone (where the metric values are displayed)format --> all metrics report metricformats an individual metric on a particular reportindividual metrics are listed in the format menu bandingrow or column grouping by colorgrid --> options column subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format -->columns -->subtotal headers or values. to set "grid unit" formatting, select the grid unit from the format menu.row subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format --> rows -->subtotal headers or values. to set "grid unit" formatting, select the ggrid unit from the format menu.overwrites column subtotal formatting where they intersect with row subtotal formattingreport bordercreates a border around the whole reportright-click on the report (but NOT a report object) then select formatting --> report borders thresholdchanges formatting based on returned data.grid --> Thresholdsoverwrites all other layers.Month_IDLast_12_Month200612200612200612200611200612200610200612200609200612200608200612200607200612200606200612200605200612200604200612200603200612200602200612200601200611200611200611200610200611200609200611200608200611200607200611200606200611200605200611200604200611200603200611200602200611200601200611200512......

     
    This layer…is overwritten by these layers…metric object - headersaxis headers, grid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersmetric object - valuesaxis values, grid unit values, all metrics values, report metric values column subtotal values row subtotal valuesaxis - headersgrid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersaxis - valuesgrid unit values, all metrics values, report metric values column subtotal values row subtotal valuesgrid unit - headersall metrics headers, report metric headers, column subtotal headers, row subtotal headersgrid unit - valuesall metrics values, report metric values column subtotal values row subtotal valuesall metrics - headersreport metric headers, column subtotal headersall metrics - valuesreport metric values column subtotal valuesreport metricbanding, column subtotals, row subtotals, thresholdbandingcolumn subtotals, row subtotals, thresholdcolumn subtotalsrow subtotals, thresholdrow subtotalsthresholdreport bordernonethresholdnoneLevelWhat is it?set it here…Notesmetricspecifies a format for a metric regardless of the report it is on.set in the metric editor."all metrics" and "axis" formatting must be set at defaultaxisaffects all units of the axis.format --> rows and columnsgrid unit formatting must be set to defaultgrid unitformatting of individual report items such as attributesgrid units are listed on the Format menu all metricformats the data zone (where the metric values are displayed)format --> all metrics report metricformats an individual metric on a particular reportindividual metrics are listed in the format menu bandingrow or column grouping by colorgrid --> options column subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format -->columns -->subtotal headers or values. to set "grid unit" formatting, select the grid unit from the format menu.row subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format --> rows -->subtotal headers or values. to set "grid unit" formatting, select the ggrid unit from the format menu.overwrites column subtotal formatting where they intersect with row subtotal formattingreport bordercreates a border around the whole reportright-click on the report (but NOT a report object) then select formatting --> report borders thresholdchanges formatting based on returned data.grid --> Thresholdsoverwrites all other layers.Month_IDLast_12_Month200612200612200612200611200612200610200612200609200612200608200612200607200612200606200612200605200612200604200612200603200612200602200612200601200611200611200611200610200611200609200611200608200611200607200611200606200611200605200611200604200611200603200611200602200611200601200611200512......

     
    This layer…is overwritten by these layers…metric object - headersaxis headers, grid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersmetric object - valuesaxis values, grid unit values, all metrics values, report metric values column subtotal values row subtotal valuesaxis - headersgrid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersaxis - valuesgrid unit values, all metrics values, report metric values column subtotal values row subtotal valuesgrid unit - headersall metrics headers, report metric headers, column subtotal headers, row subtotal headersgrid unit - valuesall metrics values, report metric values column subtotal values row subtotal valuesall metrics - headersreport metric headers, column subtotal headersall metrics - valuesreport metric values column subtotal valuesreport metricbanding, column subtotals, row subtotals, thresholdbandingcolumn subtotals, row subtotals, thresholdcolumn subtotalsrow subtotals, thresholdrow subtotalsthresholdreport bordernonethresholdnoneLevelWhat is it?set it here…Notesmetricspecifies a format for a metric regardless of the report it is on.set in the metric editor."all metrics" and "axis" formatting must be set at defaultaxisaffects all units of the axis.format --> rows and columnsgrid unit formatting must be set to defaultgrid unitformatting of individual report items such as attributesgrid units are listed on the Format menu all metricformats the data zone (where the metric values are displayed)format --> all metrics report metricformats an individual metric on a particular reportindividual metrics are listed in the format menu bandingrow or column grouping by colorgrid --> options column subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format -->columns -->subtotal headers or values. to set "grid unit" formatting, select the grid unit from the format menu.row subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format --> rows -->subtotal headers or values. to set "grid unit" formatting, select the ggrid unit from the format menu.overwrites column subtotal formatting where they intersect with row subtotal formattingreport bordercreates a border around the whole reportright-click on the report (but NOT a report object) then select formatting --> report borders thresholdchanges formatting based on returned data.grid --> Thresholdsoverwrites all other layers.Month_IDLast_12_Month200612200612200612200611200612200610200612200609200612200608200612200607200612200606200612200605200612200604200612200603200612200602200612200601200611200611200611200610200611200609200611200608200611200607200611200606200611200605200611200604200611200603200611200602200611200601200611200512......

     
    This layer…is overwritten by these layers…metric object - headersaxis headers, grid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersmetric object - valuesaxis values, grid unit values, all metrics values, report metric values column subtotal values row subtotal valuesaxis - headersgrid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersaxis - valuesgrid unit values, all metrics values, report metric values column subtotal values row subtotal valuesgrid unit - headersall metrics headers, report metric headers, column subtotal headers, row subtotal headersgrid unit - valuesall metrics values, report metric values column subtotal values row subtotal valuesall metrics - headersreport metric headers, column subtotal headersall metrics - valuesreport metric values column subtotal valuesreport metricbanding, column subtotals, row subtotals, thresholdbandingcolumn subtotals, row subtotals, thresholdcolumn subtotalsrow subtotals, thresholdrow subtotalsthresholdreport bordernonethresholdnoneLevelWhat is it?set it here…Notesmetricspecifies a format for a metric regardless of the report it is on.set in the metric editor."all metrics" and "axis" formatting must be set at defaultaxisaffects all units of the axis.format --> rows and columnsgrid unit formatting must be set to defaultgrid unitformatting of individual report items such as attributesgrid units are listed on the Format menu all metricformats the data zone (where the metric values are displayed)format --> all metrics report metricformats an individual metric on a particular reportindividual metrics are listed in the format menu bandingrow or column grouping by colorgrid --> options column subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format -->columns -->subtotal headers or values. to set "grid unit" formatting, select the grid unit from the format menu.row subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format --> rows -->subtotal headers or values. to set "grid unit" formatting, select the ggrid unit from the format menu.overwrites column subtotal formatting where they intersect with row subtotal formattingreport bordercreates a border around the whole reportright-click on the report (but NOT a report object) then select formatting --> report borders thresholdchanges formatting based on returned data.grid --> Thresholdsoverwrites all other layers.Month_IDLast_12_Month200612200612200612200611200612200610200612200609200612200608200612200607200612200606200612200605200612200604200612200603200612200602200612200601200611200611200611200610200611200609200611200608200611200607200611200606200611200605200611200604200611200603200611200602200611200601200611200512......

     
    This layer…is overwritten by these layers…metric object - headersaxis headers, grid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersmetric object - valuesaxis values, grid unit values, all metrics values, report metric values column subtotal values row subtotal valuesaxis - headersgrid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersaxis - valuesgrid unit values, all metrics values, report metric values column subtotal values row subtotal valuesgrid unit - headersall metrics headers, report metric headers, column subtotal headers, row subtotal headersgrid unit - valuesall metrics values, report metric values column subtotal values row subtotal valuesall metrics - headersreport metric headers, column subtotal headersall metrics - valuesreport metric values column subtotal valuesreport metricbanding, column subtotals, row subtotals, thresholdbandingcolumn subtotals, row subtotals, thresholdcolumn subtotalsrow subtotals, thresholdrow subtotalsthresholdreport bordernonethresholdnoneLevelWhat is it?set it here…Notesmetricspecifies a format for a metric regardless of the report it is on.set in the metric editor."all metrics" and "axis" formatting must be set at defaultaxisaffects all units of the axis.format --> rows and columnsgrid unit formatting must be set to defaultgrid unitformatting of individual report items such as attributesgrid units are listed on the Format menu all metricformats the data zone (where the metric values are displayed)format --> all metrics report metricformats an individual metric on a particular reportindividual metrics are listed in the format menu bandingrow or column grouping by colorgrid --> options column subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format -->columns -->subtotal headers or values. to set "grid unit" formatting, select the grid unit from the format menu.row subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format --> rows -->subtotal headers or values. to set "grid unit" formatting, select the ggrid unit from the format menu.overwrites column subtotal formatting where they intersect with row subtotal formattingreport bordercreates a border around the whole reportright-click on the report (but NOT a report object) then select formatting --> report borders thresholdchanges formatting based on returned data.grid --> Thresholdsoverwrites all other layers.Month_IDLast_12_Month200612200612200612200611200612200610200612200609200612200608200612200607200612200606200612200605200612200604200612200603200612200602200612200601200611200611200611200610200611200609200611200608200611200607200611200606200611200605200611200604200611200603200611200602200611200601200611200512......

     
    This layer…is overwritten by these layers…metric object - headersaxis headers, grid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersmetric object - valuesaxis values, grid unit values, all metrics values, report metric values column subtotal values row subtotal valuesaxis - headersgrid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersaxis - valuesgrid unit values, all metrics values, report metric values column subtotal values row subtotal valuesgrid unit - headersall metrics headers, report metric headers, column subtotal headers, row subtotal headersgrid unit - valuesall metrics values, report metric values column subtotal values row subtotal valuesall metrics - headersreport metric headers, column subtotal headersall metrics - valuesreport metric values column subtotal valuesreport metricbanding, column subtotals, row subtotals, thresholdbandingcolumn subtotals, row subtotals, thresholdcolumn subtotalsrow subtotals, thresholdrow subtotalsthresholdreport bordernonethresholdnoneLevelWhat is it?set it here…Notesmetricspecifies a format for a metric regardless of the report it is on.set in the metric editor."all metrics" and "axis" formatting must be set at defaultaxisaffects all units of the axis.format --> rows and columnsgrid unit formatting must be set to defaultgrid unitformatting of individual report items such as attributesgrid units are listed on the Format menu all metricformats the data zone (where the metric values are displayed)format --> all metrics report metricformats an individual metric on a particular reportindividual metrics are listed in the format menu bandingrow or column grouping by colorgrid --> options column subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format -->columns -->subtotal headers or values. to set "grid unit" formatting, select the grid unit from the format menu.row subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format --> rows -->subtotal headers or values. to set "grid unit" formatting, select the ggrid unit from the format menu.overwrites column subtotal formatting where they intersect with row subtotal formattingreport bordercreates a border around the whole reportright-click on the report (but NOT a report object) then select formatting --> report borders thresholdchanges formatting based on returned data.grid --> Thresholdsoverwrites all other layers.Month_IDLast_12_Month200612200612200612200611200612200610200612200609200612200608200612200607200612200606200612200605200612200604200612200603200612200602200612200601200611200611200611200610200611200609200611200608200611200607200611200606200611200605200611200604200611200603200611200602200611200601200611200512......

     
    This layer…is overwritten by these layers…metric object - headersaxis headers, grid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersmetric object - valuesaxis values, grid unit values, all metrics values, report metric values column subtotal values row subtotal valuesaxis - headersgrid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersaxis - valuesgrid unit values, all metrics values, report metric values column subtotal values row subtotal valuesgrid unit - headersall metrics headers, report metric headers, column subtotal headers, row subtotal headersgrid unit - valuesall metrics values, report metric values column subtotal values row subtotal valuesall metrics - headersreport metric headers, column subtotal headersall metrics - valuesreport metric values column subtotal valuesreport metricbanding, column subtotals, row subtotals, thresholdbandingcolumn subtotals, row subtotals, thresholdcolumn subtotalsrow subtotals, thresholdrow subtotalsthresholdreport bordernonethresholdnoneLevelWhat is it?set it here…Notesmetricspecifies a format for a metric regardless of the report it is on.set in the metric editor."all metrics" and "axis" formatting must be set at defaultaxisaffects all units of the axis.format --> rows and columnsgrid unit formatting must be set to defaultgrid unitformatting of individual report items such as attributesgrid units are listed on the Format menu all metricformats the data zone (where the metric values are displayed)format --> all metrics report metricformats an individual metric on a particular reportindividual metrics are listed in the format menu bandingrow or column grouping by colorgrid --> options column subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format -->columns -->subtotal headers or values. to set "grid unit" formatting, select the grid unit from the format menu.row subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format --> rows -->subtotal headers or values. to set "grid unit" formatting, select the ggrid unit from the format menu.overwrites column subtotal formatting where they intersect with row subtotal formattingreport bordercreates a border around the whole reportright-click on the report (but NOT a report object) then select formatting --> report borders thresholdchanges formatting based on returned data.grid --> Thresholdsoverwrites all other layers.Month_IDLast_12_Month200612200612200612200611200612200610200612200609200612200608200612200607200612200606200612200605200612200604200612200603200612200602200612200601200611200611200611200610200611200609200611200608200611200607200611200606200611200605200611200604200611200603200611200602200611200601200611200512......

     
    This layer…is overwritten by these layers…metric object - headersaxis headers, grid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersmetric object - valuesaxis values, grid unit values, all metrics values, report metric values column subtotal values row subtotal valuesaxis - headersgrid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersaxis - valuesgrid unit values, all metrics values, report metric values column subtotal values row subtotal valuesgrid unit - headersall metrics headers, report metric headers, column subtotal headers, row subtotal headersgrid unit - valuesall metrics values, report metric values column subtotal values row subtotal valuesall metrics - headersreport metric headers, column subtotal headersall metrics - valuesreport metric values column subtotal valuesreport metricbanding, column subtotals, row subtotals, thresholdbandingcolumn subtotals, row subtotals, thresholdcolumn subtotalsrow subtotals, thresholdrow subtotalsthresholdreport bordernonethresholdnoneLevelWhat is it?set it here…Notesmetricspecifies a format for a metric regardless of the report it is on.set in the metric editor."all metrics" and "axis" formatting must be set at defaultaxisaffects all units of the axis.format --> rows and columnsgrid unit formatting must be set to defaultgrid unitformatting of individual report items such as attributesgrid units are listed on the Format menu all metricformats the data zone (where the metric values are displayed)format --> all metrics report metricformats an individual metric on a particular reportindividual metrics are listed in the format menu bandingrow or column grouping by colorgrid --> options column subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format -->columns -->subtotal headers or values. to set "grid unit" formatting, select the grid unit from the format menu.row subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format --> rows -->subtotal headers or values. to set "grid unit" formatting, select the ggrid unit from the format menu.overwrites column subtotal formatting where they intersect with row subtotal formattingreport bordercreates a border around the whole reportright-click on the report (but NOT a report object) then select formatting --> report borders thresholdchanges formatting based on returned data.grid --> Thresholdsoverwrites all other layers.Month_IDLast_12_Month200612200612200612200611200612200610200612200609200612200608200612200607200612200606200612200605200612200604200612200603200612200602200612200601200611200611200611200610200611200609200611200608200611200607200611200606200611200605200611200604200611200603200611200602200611200601200611200512......

     
    This layer…is overwritten by these layers…metric object - headersaxis headers, grid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersmetric object - valuesaxis values, grid unit values, all metrics values, report metric values column subtotal values row subtotal valuesaxis - headersgrid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersaxis - valuesgrid unit values, all metrics values, report metric values column subtotal values row subtotal valuesgrid unit - headersall metrics headers, report metric headers, column subtotal headers, row subtotal headersgrid unit - valuesall metrics values, report metric values column subtotal values row subtotal valuesall metrics - headersreport metric headers, column subtotal headersall metrics - valuesreport metric values column subtotal valuesreport metricbanding, column subtotals, row subtotals, thresholdbandingcolumn subtotals, row subtotals, thresholdcolumn subtotalsrow subtotals, thresholdrow subtotalsthresholdreport bordernonethresholdnoneLevelWhat is it?set it here…Notesmetricspecifies a format for a metric regardless of the report it is on.set in the metric editor."all metrics" and "axis" formatting must be set at defaultaxisaffects all units of the axis.format --> rows and columnsgrid unit formatting must be set to defaultgrid unitformatting of individual report items such as attributesgrid units are listed on the Format menu all metricformats the data zone (where the metric values are displayed)format --> all metrics report metricformats an individual metric on a particular reportindividual metrics are listed in the format menu bandingrow or column grouping by colorgrid --> options column subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format -->columns -->subtotal headers or values. to set "grid unit" formatting, select the grid unit from the format menu.row subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format --> rows -->subtotal headers or values. to set "grid unit" formatting, select the ggrid unit from the format menu.overwrites column subtotal formatting where they intersect with row subtotal formattingreport bordercreates a border around the whole reportright-click on the report (but NOT a report object) then select formatting --> report borders thresholdchanges formatting based on returned data.grid --> Thresholdsoverwrites all other layers.Month_IDLast_12_Month200612200612200612200611200612200610200612200609200612200608200612200607200612200606200612200605200612200604200612200603200612200602200612200601200611200611200611200610200611200609200611200608200611200607200611200606200611200605200611200604200611200603200611200602200611200601200611200512......

     
    This layer…is overwritten by these layers…metric object - headersaxis headers, grid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersmetric object - valuesaxis values, grid unit values, all metrics values, report metric values column subtotal values row subtotal valuesaxis - headersgrid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersaxis - valuesgrid unit values, all metrics values, report metric values column subtotal values row subtotal valuesgrid unit - headersall metrics headers, report metric headers, column subtotal headers, row subtotal headersgrid unit - valuesall metrics values, report metric values column subtotal values row subtotal valuesall metrics - headersreport metric headers, column subtotal headersall metrics - valuesreport metric values column subtotal valuesreport metricbanding, column subtotals, row subtotals, thresholdbandingcolumn subtotals, row subtotals, thresholdcolumn subtotalsrow subtotals, thresholdrow subtotalsthresholdreport bordernonethresholdnoneLevelWhat is it?set it here…Notesmetricspecifies a format for a metric regardless of the report it is on.set in the metric editor."all metrics" and "axis" formatting must be set at defaultaxisaffects all units of the axis.format --> rows and columnsgrid unit formatting must be set to defaultgrid unitformatting of individual report items such as attributesgrid units are listed on the Format menu all metricformats the data zone (where the metric values are displayed)format --> all metrics report metricformats an individual metric on a particular reportindividual metrics are listed in the format menu bandingrow or column grouping by colorgrid --> options column subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format -->columns -->subtotal headers or values. to set "grid unit" formatting, select the grid unit from the format menu.row subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format --> rows -->subtotal headers or values. to set "grid unit" formatting, select the ggrid unit from the format menu.overwrites column subtotal formatting where they intersect with row subtotal formattingreport bordercreates a border around the whole reportright-click on the report (but NOT a report object) then select formatting --> report borders thresholdchanges formatting based on returned data.grid --> Thresholdsoverwrites all other layers.Month_IDLast_12_Month200612200612200612200611200612200610200612200609200612200608200612200607200612200606200612200605200612200604200612200603200612200602200612200601200611200611200611200610200611200609200611200608200611200607200611200606200611200605200611200604200611200603200611200602200611200601200611200512......

     
    This layer…is overwritten by these layers…metric object - headersaxis headers, grid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersmetric object - valuesaxis values, grid unit values, all metrics values, report metric values column subtotal values row subtotal valuesaxis - headersgrid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersaxis - valuesgrid unit values, all metrics values, report metric values column subtotal values row subtotal valuesgrid unit - headersall metrics headers, report metric headers, column subtotal headers, row subtotal headersgrid unit - valuesall metrics values, report metric values column subtotal values row subtotal valuesall metrics - headersreport metric headers, column subtotal headersall metrics - valuesreport metric values column subtotal valuesreport metricbanding, column subtotals, row subtotals, thresholdbandingcolumn subtotals, row subtotals, thresholdcolumn subtotalsrow subtotals, thresholdrow subtotalsthresholdreport bordernonethresholdnoneLevelWhat is it?set it here…Notesmetricspecifies a format for a metric regardless of the report it is on.set in the metric editor."all metrics" and "axis" formatting must be set at defaultaxisaffects all units of the axis.format --> rows and columnsgrid unit formatting must be set to defaultgrid unitformatting of individual report items such as attributesgrid units are listed on the Format menu all metricformats the data zone (where the metric values are displayed)format --> all metrics report metricformats an individual metric on a particular reportindividual metrics are listed in the format menu bandingrow or column grouping by colorgrid --> options column subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format -->columns -->subtotal headers or values. to set "grid unit" formatting, select the grid unit from the format menu.row subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format --> rows -->subtotal headers or values. to set "grid unit" formatting, select the ggrid unit from the format menu.overwrites column subtotal formatting where they intersect with row subtotal formattingreport bordercreates a border around the whole reportright-click on the report (but NOT a report object) then select formatting --> report borders thresholdchanges formatting based on returned data.grid --> Thresholdsoverwrites all other layers.Month_IDLast_12_Month200612200612200612200611200612200610200612200609200612200608200612200607200612200606200612200605200612200604200612200603200612200602200612200601200611200611200611200610200611200609200611200608200611200607200611200606200611200605200611200604200611200603200611200602200611200601200611200512......

     
    This layer…is overwritten by these layers…metric object - headersaxis headers, grid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersmetric object - valuesaxis values, grid unit values, all metrics values, report metric values column subtotal values row subtotal valuesaxis - headersgrid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersaxis - valuesgrid unit values, all metrics values, report metric values column subtotal values row subtotal valuesgrid unit - headersall metrics headers, report metric headers, column subtotal headers, row subtotal headersgrid unit - valuesall metrics values, report metric values column subtotal values row subtotal valuesall metrics - headersreport metric headers, column subtotal headersall metrics - valuesreport metric values column subtotal valuesreport metricbanding, column subtotals, row subtotals, thresholdbandingcolumn subtotals, row subtotals, thresholdcolumn subtotalsrow subtotals, thresholdrow subtotalsthresholdreport bordernonethresholdnoneLevelWhat is it?set it here…Notesmetricspecifies a format for a metric regardless of the report it is on.set in the metric editor."all metrics" and "axis" formatting must be set at defaultaxisaffects all units of the axis.format --> rows and columnsgrid unit formatting must be set to defaultgrid unitformatting of individual report items such as attributesgrid units are listed on the Format menu all metricformats the data zone (where the metric values are displayed)format --> all metrics report metricformats an individual metric on a particular reportindividual metrics are listed in the format menu bandingrow or column grouping by colorgrid --> options column subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format -->columns -->subtotal headers or values. to set "grid unit" formatting, select the grid unit from the format menu.row subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format --> rows -->subtotal headers or values. to set "grid unit" formatting, select the ggrid unit from the format menu.overwrites column subtotal formatting where they intersect with row subtotal formattingreport bordercreates a border around the whole reportright-click on the report (but NOT a report object) then select formatting --> report borders thresholdchanges formatting based on returned data.grid --> Thresholdsoverwrites all other layers.Month_IDLast_12_Month200612200612200612200611200612200610200612200609200612200608200612200607200612200606200612200605200612200604200612200603200612200602200612200601200611200611200611200610200611200609200611200608200611200607200611200606200611200605200611200604200611200603200611200602200611200601200611200512......

     
    This layer…is overwritten by these layers…metric object - headersaxis headers, grid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersmetric object - valuesaxis values, grid unit values, all metrics values, report metric values column subtotal values row subtotal valuesaxis - headersgrid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersaxis - valuesgrid unit values, all metrics values, report metric values column subtotal values row subtotal valuesgrid unit - headersall metrics headers, report metric headers, column subtotal headers, row subtotal headersgrid unit - valuesall metrics values, report metric values column subtotal values row subtotal valuesall metrics - headersreport metric headers, column subtotal headersall metrics - valuesreport metric values column subtotal valuesreport metricbanding, column subtotals, row subtotals, thresholdbandingcolumn subtotals, row subtotals, thresholdcolumn subtotalsrow subtotals, thresholdrow subtotalsthresholdreport bordernonethresholdnoneLevelWhat is it?set it here…Notesmetricspecifies a format for a metric regardless of the report it is on.set in the metric editor."all metrics" and "axis" formatting must be set at defaultaxisaffects all units of the axis.format --> rows and columnsgrid unit formatting must be set to defaultgrid unitformatting of individual report items such as attributesgrid units are listed on the Format menu all metricformats the data zone (where the metric values are displayed)format --> all metrics report metricformats an individual metric on a particular reportindividual metrics are listed in the format menu bandingrow or column grouping by colorgrid --> options column subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format -->columns -->subtotal headers or values. to set "grid unit" formatting, select the grid unit from the format menu.row subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format --> rows -->subtotal headers or values. to set "grid unit" formatting, select the ggrid unit from the format menu.overwrites column subtotal formatting where they intersect with row subtotal formattingreport bordercreates a border around the whole reportright-click on the report (but NOT a report object) then select formatting --> report borders thresholdchanges formatting based on returned data.grid --> Thresholdsoverwrites all other layers.Month_IDLast_12_Month200612200612200612200611200612200610200612200609200612200608200612200607200612200606200612200605200612200604200612200603200612200602200612200601200611200611200611200610200611200609200611200608200611200607200611200606200611200605200611200604200611200603200611200602200611200601200611200512......

     
    This layer…is overwritten by these layers…metric object - headersaxis headers, grid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersmetric object - valuesaxis values, grid unit values, all metrics values, report metric values column subtotal values row subtotal valuesaxis - headersgrid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersaxis - valuesgrid unit values, all metrics values, report metric values column subtotal values row subtotal valuesgrid unit - headersall metrics headers, report metric headers, column subtotal headers, row subtotal headersgrid unit - valuesall metrics values, report metric values column subtotal values row subtotal valuesall metrics - headersreport metric headers, column subtotal headersall metrics - valuesreport metric values column subtotal valuesreport metricbanding, column subtotals, row subtotals, thresholdbandingcolumn subtotals, row subtotals, thresholdcolumn subtotalsrow subtotals, thresholdrow subtotalsthresholdreport bordernonethresholdnoneLevelWhat is it?set it here…Notesmetricspecifies a format for a metric regardless of the report it is on.set in the metric editor."all metrics" and "axis" formatting must be set at defaultaxisaffects all units of the axis.format --> rows and columnsgrid unit formatting must be set to defaultgrid unitformatting of individual report items such as attributesgrid units are listed on the Format menu all metricformats the data zone (where the metric values are displayed)format --> all metrics report metricformats an individual metric on a particular reportindividual metrics are listed in the format menu bandingrow or column grouping by colorgrid --> options column subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format -->columns -->subtotal headers or values. to set "grid unit" formatting, select the grid unit from the format menu.row subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format --> rows -->subtotal headers or values. to set "grid unit" formatting, select the ggrid unit from the format menu.overwrites column subtotal formatting where they intersect with row subtotal formattingreport bordercreates a border around the whole reportright-click on the report (but NOT a report object) then select formatting --> report borders thresholdchanges formatting based on returned data.grid --> Thresholdsoverwrites all other layers.Month_IDLast_12_Month200612200612200612200611200612200610200612200609200612200608200612200607200612200606200612200605200612200604200612200603200612200602200612200601200611200611200611200610200611200609200611200608200611200607200611200606200611200605200611200604200611200603200611200602200611200601200611200512......

     
    This layer…is overwritten by these layers…metric object - headersaxis headers, grid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersmetric object - valuesaxis values, grid unit values, all metrics values, report metric values column subtotal values row subtotal valuesaxis - headersgrid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersaxis - valuesgrid unit values, all metrics values, report metric values column subtotal values row subtotal valuesgrid unit - headersall metrics headers, report metric headers, column subtotal headers, row subtotal headersgrid unit - valuesall metrics values, report metric values column subtotal values row subtotal valuesall metrics - headersreport metric headers, column subtotal headersall metrics - valuesreport metric values column subtotal valuesreport metricbanding, column subtotals, row subtotals, thresholdbandingcolumn subtotals, row subtotals, thresholdcolumn subtotalsrow subtotals, thresholdrow subtotalsthresholdreport bordernonethresholdnoneLevelWhat is it?set it here…Notesmetricspecifies a format for a metric regardless of the report it is on.set in the metric editor."all metrics" and "axis" formatting must be set at defaultaxisaffects all units of the axis.format --> rows and columnsgrid unit formatting must be set to defaultgrid unitformatting of individual report items such as attributesgrid units are listed on the Format menu all metricformats the data zone (where the metric values are displayed)format --> all metrics report metricformats an individual metric on a particular reportindividual metrics are listed in the format menu bandingrow or column grouping by colorgrid --> options column subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format -->columns -->subtotal headers or values. to set "grid unit" formatting, select the grid unit from the format menu.row subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format --> rows -->subtotal headers or values. to set "grid unit" formatting, select the ggrid unit from the format menu.overwrites column subtotal formatting where they intersect with row subtotal formattingreport bordercreates a border around the whole reportright-click on the report (but NOT a report object) then select formatting --> report borders thresholdchanges formatting based on returned data.grid --> Thresholdsoverwrites all other layers.Month_IDLast_12_Month200612200612200612200611200612200610200612200609200612200608200612200607200612200606200612200605200612200604200612200603200612200602200612200601200611200611200611200610200611200609200611200608200611200607200611200606200611200605200611200604200611200603200611200602200611200601200611200512......

     
    This layer…is overwritten by these layers…metric object - headersaxis headers, grid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersmetric object - valuesaxis values, grid unit values, all metrics values, report metric values column subtotal values row subtotal valuesaxis - headersgrid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersaxis - valuesgrid unit values, all metrics values, report metric values column subtotal values row subtotal valuesgrid unit - headersall metrics headers, report metric headers, column subtotal headers, row subtotal headersgrid unit - valuesall metrics values, report metric values column subtotal values row subtotal valuesall metrics - headersreport metric headers, column subtotal headersall metrics - valuesreport metric values column subtotal valuesreport metricbanding, column subtotals, row subtotals, thresholdbandingcolumn subtotals, row subtotals, thresholdcolumn subtotalsrow subtotals, thresholdrow subtotalsthresholdreport bordernonethresholdnoneLevelWhat is it?set it here…Notesmetricspecifies a format for a metric regardless of the report it is on.set in the metric editor."all metrics" and "axis" formatting must be set at defaultaxisaffects all units of the axis.format --> rows and columnsgrid unit formatting must be set to defaultgrid unitformatting of individual report items such as attributesgrid units are listed on the Format menu all metricformats the data zone (where the metric values are displayed)format --> all metrics report metricformats an individual metric on a particular reportindividual metrics are listed in the format menu bandingrow or column grouping by colorgrid --> options column subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format -->columns -->subtotal headers or values. to set "grid unit" formatting, select the grid unit from the format menu.row subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format --> rows -->subtotal headers or values. to set "grid unit" formatting, select the ggrid unit from the format menu.overwrites column subtotal formatting where they intersect with row subtotal formattingreport bordercreates a border around the whole reportright-click on the report (but NOT a report object) then select formatting --> report borders thresholdchanges formatting based on returned data.grid --> Thresholdsoverwrites all other layers.Month_IDLast_12_Month200612200612200612200611200612200610200612200609200612200608200612200607200612200606200612200605200612200604200612200603200612200602200612200601200611200611200611200610200611200609200611200608200611200607200611200606200611200605200611200604200611200603200611200602200611200601200611200512......

     
    This layer…is overwritten by these layers…metric object - headersaxis headers, grid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersmetric object - valuesaxis values, grid unit values, all metrics values, report metric values column subtotal values row subtotal valuesaxis - headersgrid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersaxis - valuesgrid unit values, all metrics values, report metric values column subtotal values row subtotal valuesgrid unit - headersall metrics headers, report metric headers, column subtotal headers, row subtotal headersgrid unit - valuesall metrics values, report metric values column subtotal values row subtotal valuesall metrics - headersreport metric headers, column subtotal headersall metrics - valuesreport metric values column subtotal valuesreport metricbanding, column subtotals, row subtotals, thresholdbandingcolumn subtotals, row subtotals, thresholdcolumn subtotalsrow subtotals, thresholdrow subtotalsthresholdreport bordernonethresholdnoneLevelWhat is it?set it here…Notesmetricspecifies a format for a metric regardless of the report it is on.set in the metric editor."all metrics" and "axis" formatting must be set at defaultaxisaffects all units of the axis.format --> rows and columnsgrid unit formatting must be set to defaultgrid unitformatting of individual report items such as attributesgrid units are listed on the Format menu all metricformats the data zone (where the metric values are displayed)format --> all metrics report metricformats an individual metric on a particular reportindividual metrics are listed in the format menu bandingrow or column grouping by colorgrid --> options column subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format -->columns -->subtotal headers or values. to set "grid unit" formatting, select the grid unit from the format menu.row subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format --> rows -->subtotal headers or values. to set "grid unit" formatting, select the ggrid unit from the format menu.overwrites column subtotal formatting where they intersect with row subtotal formattingreport bordercreates a border around the whole reportright-click on the report (but NOT a report object) then select formatting --> report borders thresholdchanges formatting based on returned data.grid --> Thresholdsoverwrites all other layers.Month_IDLast_12_Month200612200612200612200611200612200610200612200609200612200608200612200607200612200606200612200605200612200604200612200603200612200602200612200601200611200611200611200610200611200609200611200608200611200607200611200606200611200605200611200604200611200603200611200602200611200601200611200512......

     
    This layer…is overwritten by these layers…metric object - headersaxis headers, grid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersmetric object - valuesaxis values, grid unit values, all metrics values, report metric values column subtotal values row subtotal valuesaxis - headersgrid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersaxis - valuesgrid unit values, all metrics values, report metric values column subtotal values row subtotal valuesgrid unit - headersall metrics headers, report metric headers, column subtotal headers, row subtotal headersgrid unit - valuesall metrics values, report metric values column subtotal values row subtotal valuesall metrics - headersreport metric headers, column subtotal headersall metrics - valuesreport metric values column subtotal valuesreport metricbanding, column subtotals, row subtotals, thresholdbandingcolumn subtotals, row subtotals, thresholdcolumn subtotalsrow subtotals, thresholdrow subtotalsthresholdreport bordernonethresholdnoneLevelWhat is it?set it here…Notesmetricspecifies a format for a metric regardless of the report it is on.set in the metric editor."all metrics" and "axis" formatting must be set at defaultaxisaffects all units of the axis.format --> rows and columnsgrid unit formatting must be set to defaultgrid unitformatting of individual report items such as attributesgrid units are listed on the Format menu all metricformats the data zone (where the metric values are displayed)format --> all metrics report metricformats an individual metric on a particular reportindividual metrics are listed in the format menu bandingrow or column grouping by colorgrid --> options column subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format -->columns -->subtotal headers or values. to set "grid unit" formatting, select the grid unit from the format menu.row subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format --> rows -->subtotal headers or values. to set "grid unit" formatting, select the ggrid unit from the format menu.overwrites column subtotal formatting where they intersect with row subtotal formattingreport bordercreates a border around the whole reportright-click on the report (but NOT a report object) then select formatting --> report borders thresholdchanges formatting based on returned data.grid --> Thresholdsoverwrites all other layers.Month_IDLast_12_Month200612200612200612200611200612200610200612200609200612200608200612200607200612200606200612200605200612200604200612200603200612200602200612200601200611200611200611200610200611200609200611200608200611200607200611200606200611200605200611200604200611200603200611200602200611200601200611200512......

     
    This layer…is overwritten by these layers…metric object - headersaxis headers, grid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersmetric object - valuesaxis values, grid unit values, all metrics values, report metric values column subtotal values row subtotal valuesaxis - headersgrid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersaxis - valuesgrid unit values, all metrics values, report metric values column subtotal values row subtotal valuesgrid unit - headersall metrics headers, report metric headers, column subtotal headers, row subtotal headersgrid unit - valuesall metrics values, report metric values column subtotal values row subtotal valuesall metrics - headersreport metric headers, column subtotal headersall metrics - valuesreport metric values column subtotal valuesreport metricbanding, column subtotals, row subtotals, thresholdbandingcolumn subtotals, row subtotals, thresholdcolumn subtotalsrow subtotals, thresholdrow subtotalsthresholdreport bordernonethresholdnoneLevelWhat is it?set it here…Notesmetricspecifies a format for a metric regardless of the report it is on.set in the metric editor."all metrics" and "axis" formatting must be set at defaultaxisaffects all units of the axis.format --> rows and columnsgrid unit formatting must be set to defaultgrid unitformatting of individual report items such as attributesgrid units are listed on the Format menu all metricformats the data zone (where the metric values are displayed)format --> all metrics report metricformats an individual metric on a particular reportindividual metrics are listed in the format menu bandingrow or column grouping by colorgrid --> options column subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format -->columns -->subtotal headers or values. to set "grid unit" formatting, select the grid unit from the format menu.row subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format --> rows -->subtotal headers or values. to set "grid unit" formatting, select the ggrid unit from the format menu.overwrites column subtotal formatting where they intersect with row subtotal formattingreport bordercreates a border around the whole reportright-click on the report (but NOT a report object) then select formatting --> report borders thresholdchanges formatting based on returned data.grid --> Thresholdsoverwrites all other layers.Month_IDLast_12_Month200612200612200612200611200612200610200612200609200612200608200612200607200612200606200612200605200612200604200612200603200612200602200612200601200611200611200611200610200611200609200611200608200611200607200611200606200611200605200611200604200611200603200611200602200611200601200611200512......

     
    This layer…is overwritten by these layers…metric object - headersaxis headers, grid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersmetric object - valuesaxis values, grid unit values, all metrics values, report metric values column subtotal values row subtotal valuesaxis - headersgrid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersaxis - valuesgrid unit values, all metrics values, report metric values column subtotal values row subtotal valuesgrid unit - headersall metrics headers, report metric headers, column subtotal headers, row subtotal headersgrid unit - valuesall metrics values, report metric values column subtotal values row subtotal valuesall metrics - headersreport metric headers, column subtotal headersall metrics - valuesreport metric values column subtotal valuesreport metricbanding, column subtotals, row subtotals, thresholdbandingcolumn subtotals, row subtotals, thresholdcolumn subtotalsrow subtotals, thresholdrow subtotalsthresholdreport bordernonethresholdnoneLevelWhat is it?set it here…Notesmetricspecifies a format for a metric regardless of the report it is on.set in the metric editor."all metrics" and "axis" formatting must be set at defaultaxisaffects all units of the axis.format --> rows and columnsgrid unit formatting must be set to defaultgrid unitformatting of individual report items such as attributesgrid units are listed on the Format menu all metricformats the data zone (where the metric values are displayed)format --> all metrics report metricformats an individual metric on a particular reportindividual metrics are listed in the format menu bandingrow or column grouping by colorgrid --> options column subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format -->columns -->subtotal headers or values. to set "grid unit" formatting, select the grid unit from the format menu.row subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format --> rows -->subtotal headers or values. to set "grid unit" formatting, select the ggrid unit from the format menu.overwrites column subtotal formatting where they intersect with row subtotal formattingreport bordercreates a border around the whole reportright-click on the report (but NOT a report object) then select formatting --> report borders thresholdchanges formatting based on returned data.grid --> Thresholdsoverwrites all other layers.Month_IDLast_12_Month200612200612200612200611200612200610200612200609200612200608200612200607200612200606200612200605200612200604200612200603200612200602200612200601200611200611200611200610200611200609200611200608200611200607200611200606200611200605200611200604200611200603200611200602200611200601200611200512......

     
    This layer…is overwritten by these layers…metric object - headersaxis headers, grid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersmetric object - valuesaxis values, grid unit values, all metrics values, report metric values column subtotal values row subtotal valuesaxis - headersgrid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersaxis - valuesgrid unit values, all metrics values, report metric values column subtotal values row subtotal valuesgrid unit - headersall metrics headers, report metric headers, column subtotal headers, row subtotal headersgrid unit - valuesall metrics values, report metric values column subtotal values row subtotal valuesall metrics - headersreport metric headers, column subtotal headersall metrics - valuesreport metric values column subtotal valuesreport metricbanding, column subtotals, row subtotals, thresholdbandingcolumn subtotals, row subtotals, thresholdcolumn subtotalsrow subtotals, thresholdrow subtotalsthresholdreport bordernonethresholdnoneLevelWhat is it?set it here…Notesmetricspecifies a format for a metric regardless of the report it is on.set in the metric editor."all metrics" and "axis" formatting must be set at defaultaxisaffects all units of the axis.format --> rows and columnsgrid unit formatting must be set to defaultgrid unitformatting of individual report items such as attributesgrid units are listed on the Format menu all metricformats the data zone (where the metric values are displayed)format --> all metrics report metricformats an individual metric on a particular reportindividual metrics are listed in the format menu bandingrow or column grouping by colorgrid --> options column subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format -->columns -->subtotal headers or values. to set "grid unit" formatting, select the grid unit from the format menu.row subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format --> rows -->subtotal headers or values. to set "grid unit" formatting, select the ggrid unit from the format menu.overwrites column subtotal formatting where they intersect with row subtotal formattingreport bordercreates a border around the whole reportright-click on the report (but NOT a report object) then select formatting --> report borders thresholdchanges formatting based on returned data.grid --> Thresholdsoverwrites all other layers.Month_IDLast_12_Month200612200612200612200611200612200610200612200609200612200608200612200607200612200606200612200605200612200604200612200603200612200602200612200601200611200611200611200610200611200609200611200608200611200607200611200606200611200605200611200604200611200603200611200602200611200601200611200512......

     
    This layer…is overwritten by these layers…metric object - headersaxis headers, grid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersmetric object - valuesaxis values, grid unit values, all metrics values, report metric values column subtotal values row subtotal valuesaxis - headersgrid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersaxis - valuesgrid unit values, all metrics values, report metric values column subtotal values row subtotal valuesgrid unit - headersall metrics headers, report metric headers, column subtotal headers, row subtotal headersgrid unit - valuesall metrics values, report metric values column subtotal values row subtotal valuesall metrics - headersreport metric headers, column subtotal headersall metrics - valuesreport metric values column subtotal valuesreport metricbanding, column subtotals, row subtotals, thresholdbandingcolumn subtotals, row subtotals, thresholdcolumn subtotalsrow subtotals, thresholdrow subtotalsthresholdreport bordernonethresholdnoneLevelWhat is it?set it here…Notesmetricspecifies a format for a metric regardless of the report it is on.set in the metric editor."all metrics" and "axis" formatting must be set at defaultaxisaffects all units of the axis.format --> rows and columnsgrid unit formatting must be set to defaultgrid unitformatting of individual report items such as attributesgrid units are listed on the Format menu all metricformats the data zone (where the metric values are displayed)format --> all metrics report metricformats an individual metric on a particular reportindividual metrics are listed in the format menu bandingrow or column grouping by colorgrid --> options column subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format -->columns -->subtotal headers or values. to set "grid unit" formatting, select the grid unit from the format menu.row subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format --> rows -->subtotal headers or values. to set "grid unit" formatting, select the ggrid unit from the format menu.overwrites column subtotal formatting where they intersect with row subtotal formattingreport bordercreates a border around the whole reportright-click on the report (but NOT a report object) then select formatting --> report borders thresholdchanges formatting based on returned data.grid --> Thresholdsoverwrites all other layers.Month_IDLast_12_Month200612200612200612200611200612200610200612200609200612200608200612200607200612200606200612200605200612200604200612200603200612200602200612200601200611200611200611200610200611200609200611200608200611200607200611200606200611200605200611200604200611200603200611200602200611200601200611200512......

     
    This layer…is overwritten by these layers…metric object - headersaxis headers, grid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersmetric object - valuesaxis values, grid unit values, all metrics values, report metric values column subtotal values row subtotal valuesaxis - headersgrid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersaxis - valuesgrid unit values, all metrics values, report metric values column subtotal values row subtotal valuesgrid unit - headersall metrics headers, report metric headers, column subtotal headers, row subtotal headersgrid unit - valuesall metrics values, report metric values column subtotal values row subtotal valuesall metrics - headersreport metric headers, column subtotal headersall metrics - valuesreport metric values column subtotal valuesreport metricbanding, column subtotals, row subtotals, thresholdbandingcolumn subtotals, row subtotals, thresholdcolumn subtotalsrow subtotals, thresholdrow subtotalsthresholdreport bordernonethresholdnoneLevelWhat is it?set it here…Notesmetricspecifies a format for a metric regardless of the report it is on.set in the metric editor."all metrics" and "axis" formatting must be set at defaultaxisaffects all units of the axis.format --> rows and columnsgrid unit formatting must be set to defaultgrid unitformatting of individual report items such as attributesgrid units are listed on the Format menu all metricformats the data zone (where the metric values are displayed)format --> all metrics report metricformats an individual metric on a particular reportindividual metrics are listed in the format menu bandingrow or column grouping by colorgrid --> options column subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format -->columns -->subtotal headers or values. to set "grid unit" formatting, select the grid unit from the format menu.row subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format --> rows -->subtotal headers or values. to set "grid unit" formatting, select the ggrid unit from the format menu.overwrites column subtotal formatting where they intersect with row subtotal formattingreport bordercreates a border around the whole reportright-click on the report (but NOT a report object) then select formatting --> report borders thresholdchanges formatting based on returned data.grid --> Thresholdsoverwrites all other layers.Month_IDLast_12_Month200612200612200612200611200612200610200612200609200612200608200612200607200612200606200612200605200612200604200612200603200612200602200612200601200611200611200611200610200611200609200611200608200611200607200611200606200611200605200611200604200611200603200611200602200611200601200611200512......

     
    This layer…is overwritten by these layers…metric object - headersaxis headers, grid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersmetric object - valuesaxis values, grid unit values, all metrics values, report metric values column subtotal values row subtotal valuesaxis - headersgrid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersaxis - valuesgrid unit values, all metrics values, report metric values column subtotal values row subtotal valuesgrid unit - headersall metrics headers, report metric headers, column subtotal headers, row subtotal headersgrid unit - valuesall metrics values, report metric values column subtotal values row subtotal valuesall metrics - headersreport metric headers, column subtotal headersall metrics - valuesreport metric values column subtotal valuesreport metricbanding, column subtotals, row subtotals, thresholdbandingcolumn subtotals, row subtotals, thresholdcolumn subtotalsrow subtotals, thresholdrow subtotalsthresholdreport bordernonethresholdnoneLevelWhat is it?set it here…Notesmetricspecifies a format for a metric regardless of the report it is on.set in the metric editor."all metrics" and "axis" formatting must be set at defaultaxisaffects all units of the axis.format --> rows and columnsgrid unit formatting must be set to defaultgrid unitformatting of individual report items such as attributesgrid units are listed on the Format menu all metricformats the data zone (where the metric values are displayed)format --> all metrics report metricformats an individual metric on a particular reportindividual metrics are listed in the format menu bandingrow or column grouping by colorgrid --> options column subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format -->columns -->subtotal headers or values. to set "grid unit" formatting, select the grid unit from the format menu.row subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format --> rows -->subtotal headers or values. to set "grid unit" formatting, select the ggrid unit from the format menu.overwrites column subtotal formatting where they intersect with row subtotal formattingreport bordercreates a border around the whole reportright-click on the report (but NOT a report object) then select formatting --> report borders thresholdchanges formatting based on returned data.grid --> Thresholdsoverwrites all other layers.Month_IDLast_12_Month200612200612200612200611200612200610200612200609200612200608200612200607200612200606200612200605200612200604200612200603200612200602200612200601200611200611200611200610200611200609200611200608200611200607200611200606200611200605200611200604200611200603200611200602200611200601200611200512......

     
    This layer…is overwritten by these layers…metric object - headersaxis headers, grid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersmetric object - valuesaxis values, grid unit values, all metrics values, report metric values column subtotal values row subtotal valuesaxis - headersgrid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersaxis - valuesgrid unit values, all metrics values, report metric values column subtotal values row subtotal valuesgrid unit - headersall metrics headers, report metric headers, column subtotal headers, row subtotal headersgrid unit - valuesall metrics values, report metric values column subtotal values row subtotal valuesall metrics - headersreport metric headers, column subtotal headersall metrics - valuesreport metric values column subtotal valuesreport metricbanding, column subtotals, row subtotals, thresholdbandingcolumn subtotals, row subtotals, thresholdcolumn subtotalsrow subtotals, thresholdrow subtotalsthresholdreport bordernonethresholdnoneLevelWhat is it?set it here…Notesmetricspecifies a format for a metric regardless of the report it is on.set in the metric editor."all metrics" and "axis" formatting must be set at defaultaxisaffects all units of the axis.format --> rows and columnsgrid unit formatting must be set to defaultgrid unitformatting of individual report items such as attributesgrid units are listed on the Format menu all metricformats the data zone (where the metric values are displayed)format --> all metrics report metricformats an individual metric on a particular reportindividual metrics are listed in the format menu bandingrow or column grouping by colorgrid --> options column subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format -->columns -->subtotal headers or values. to set "grid unit" formatting, select the grid unit from the format menu.row subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format --> rows -->subtotal headers or values. to set "grid unit" formatting, select the ggrid unit from the format menu.overwrites column subtotal formatting where they intersect with row subtotal formattingreport bordercreates a border around the whole reportright-click on the report (but NOT a report object) then select formatting --> report borders thresholdchanges formatting based on returned data.grid --> Thresholdsoverwrites all other layers.Month_IDLast_12_Month200612200612200612200611200612200610200612200609200612200608200612200607200612200606200612200605200612200604200612200603200612200602200612200601200611200611200611200610200611200609200611200608200611200607200611200606200611200605200611200604200611200603200611200602200611200601200611200512......

     
    This layer…is overwritten by these layers…metric object - headersaxis headers, grid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersmetric object - valuesaxis values, grid unit values, all metrics values, report metric values column subtotal values row subtotal valuesaxis - headersgrid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersaxis - valuesgrid unit values, all metrics values, report metric values column subtotal values row subtotal valuesgrid unit - headersall metrics headers, report metric headers, column subtotal headers, row subtotal headersgrid unit - valuesall metrics values, report metric values column subtotal values row subtotal valuesall metrics - headersreport metric headers, column subtotal headersall metrics - valuesreport metric values column subtotal valuesreport metricbanding, column subtotals, row subtotals, thresholdbandingcolumn subtotals, row subtotals, thresholdcolumn subtotalsrow subtotals, thresholdrow subtotalsthresholdreport bordernonethresholdnoneLevelWhat is it?set it here…Notesmetricspecifies a format for a metric regardless of the report it is on.set in the metric editor."all metrics" and "axis" formatting must be set at defaultaxisaffects all units of the axis.format --> rows and columnsgrid unit formatting must be set to defaultgrid unitformatting of individual report items such as attributesgrid units are listed on the Format menu all metricformats the data zone (where the metric values are displayed)format --> all metrics report metricformats an individual metric on a particular reportindividual metrics are listed in the format menu bandingrow or column grouping by colorgrid --> options column subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format -->columns -->subtotal headers or values. to set "grid unit" formatting, select the grid unit from the format menu.row subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format --> rows -->subtotal headers or values. to set "grid unit" formatting, select the ggrid unit from the format menu.overwrites column subtotal formatting where they intersect with row subtotal formattingreport bordercreates a border around the whole reportright-click on the report (but NOT a report object) then select formatting --> report borders thresholdchanges formatting based on returned data.grid --> Thresholdsoverwrites all other layers.Month_IDLast_12_Month200612200612200612200611200612200610200612200609200612200608200612200607200612200606200612200605200612200604200612200603200612200602200612200601200611200611200611200610200611200609200611200608200611200607200611200606200611200605200611200604200611200603200611200602200611200601200611200512......

     
    This layer…is overwritten by these layers…metric object - headersaxis headers, grid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersmetric object - valuesaxis values, grid unit values, all metrics values, report metric values column subtotal values row subtotal valuesaxis - headersgrid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersaxis - valuesgrid unit values, all metrics values, report metric values column subtotal values row subtotal valuesgrid unit - headersall metrics headers, report metric headers, column subtotal headers, row subtotal headersgrid unit - valuesall metrics values, report metric values column subtotal values row subtotal valuesall metrics - headersreport metric headers, column subtotal headersall metrics - valuesreport metric values column subtotal valuesreport metricbanding, column subtotals, row subtotals, thresholdbandingcolumn subtotals, row subtotals, thresholdcolumn subtotalsrow subtotals, thresholdrow subtotalsthresholdreport bordernonethresholdnoneLevelWhat is it?set it here…Notesmetricspecifies a format for a metric regardless of the report it is on.set in the metric editor."all metrics" and "axis" formatting must be set at defaultaxisaffects all units of the axis.format --> rows and columnsgrid unit formatting must be set to defaultgrid unitformatting of individual report items such as attributesgrid units are listed on the Format menu all metricformats the data zone (where the metric values are displayed)format --> all metrics report metricformats an individual metric on a particular reportindividual metrics are listed in the format menu bandingrow or column grouping by colorgrid --> options column subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format -->columns -->subtotal headers or values. to set "grid unit" formatting, select the grid unit from the format menu.row subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format --> rows -->subtotal headers or values. to set "grid unit" formatting, select the ggrid unit from the format menu.overwrites column subtotal formatting where they intersect with row subtotal formattingreport bordercreates a border around the whole reportright-click on the report (but NOT a report object) then select formatting --> report borders thresholdchanges formatting based on returned data.grid --> Thresholdsoverwrites all other layers.Month_IDLast_12_Month200612200612200612200611200612200610200612200609200612200608200612200607200612200606200612200605200612200604200612200603200612200602200612200601200611200611200611200610200611200609200611200608200611200607200611200606200611200605200611200604200611200603200611200602200611200601200611200512......

     
    This layer…is overwritten by these layers…metric object - headersaxis headers, grid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersmetric object - valuesaxis values, grid unit values, all metrics values, report metric values column subtotal values row subtotal valuesaxis - headersgrid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersaxis - valuesgrid unit values, all metrics values, report metric values column subtotal values row subtotal valuesgrid unit - headersall metrics headers, report metric headers, column subtotal headers, row subtotal headersgrid unit - valuesall metrics values, report metric values column subtotal values row subtotal valuesall metrics - headersreport metric headers, column subtotal headersall metrics - valuesreport metric values column subtotal valuesreport metricbanding, column subtotals, row subtotals, thresholdbandingcolumn subtotals, row subtotals, thresholdcolumn subtotalsrow subtotals, thresholdrow subtotalsthresholdreport bordernonethresholdnoneLevelWhat is it?set it here…Notesmetricspecifies a format for a metric regardless of the report it is on.set in the metric editor."all metrics" and "axis" formatting must be set at defaultaxisaffects all units of the axis.format --> rows and columnsgrid unit formatting must be set to defaultgrid unitformatting of individual report items such as attributesgrid units are listed on the Format menu all metricformats the data zone (where the metric values are displayed)format --> all metrics report metricformats an individual metric on a particular reportindividual metrics are listed in the format menu bandingrow or column grouping by colorgrid --> options column subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format -->columns -->subtotal headers or values. to set "grid unit" formatting, select the grid unit from the format menu.row subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format --> rows -->subtotal headers or values. to set "grid unit" formatting, select the ggrid unit from the format menu.overwrites column subtotal formatting where they intersect with row subtotal formattingreport bordercreates a border around the whole reportright-click on the report (but NOT a report object) then select formatting --> report borders thresholdchanges formatting based on returned data.grid --> Thresholdsoverwrites all other layers.Month_IDLast_12_Month200612200612200612200611200612200610200612200609200612200608200612200607200612200606200612200605200612200604200612200603200612200602200612200601200611200611200611200610200611200609200611200608200611200607200611200606200611200605200611200604200611200603200611200602200611200601200611200512......

     
    This layer…is overwritten by these layers…metric object - headersaxis headers, grid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersmetric object - valuesaxis values, grid unit values, all metrics values, report metric values column subtotal values row subtotal valuesaxis - headersgrid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersaxis - valuesgrid unit values, all metrics values, report metric values column subtotal values row subtotal valuesgrid unit - headersall metrics headers, report metric headers, column subtotal headers, row subtotal headersgrid unit - valuesall metrics values, report metric values column subtotal values row subtotal valuesall metrics - headersreport metric headers, column subtotal headersall metrics - valuesreport metric values column subtotal valuesreport metricbanding, column subtotals, row subtotals, thresholdbandingcolumn subtotals, row subtotals, thresholdcolumn subtotalsrow subtotals, thresholdrow subtotalsthresholdreport bordernonethresholdnoneLevelWhat is it?set it here…Notesmetricspecifies a format for a metric regardless of the report it is on.set in the metric editor."all metrics" and "axis" formatting must be set at defaultaxisaffects all units of the axis.format --> rows and columnsgrid unit formatting must be set to defaultgrid unitformatting of individual report items such as attributesgrid units are listed on the Format menu all metricformats the data zone (where the metric values are displayed)format --> all metrics report metricformats an individual metric on a particular reportindividual metrics are listed in the format menu bandingrow or column grouping by colorgrid --> options column subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format -->columns -->subtotal headers or values. to set "grid unit" formatting, select the grid unit from the format menu.row subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format --> rows -->subtotal headers or values. to set "grid unit" formatting, select the ggrid unit from the format menu.overwrites column subtotal formatting where they intersect with row subtotal formattingreport bordercreates a border around the whole reportright-click on the report (but NOT a report object) then select formatting --> report borders thresholdchanges formatting based on returned data.grid --> Thresholdsoverwrites all other layers.Month_IDLast_12_Month200612200612200612200611200612200610200612200609200612200608200612200607200612200606200612200605200612200604200612200603200612200602200612200601200611200611200611200610200611200609200611200608200611200607200611200606200611200605200611200604200611200603200611200602200611200601200611200512......

     
    This layer…is overwritten by these layers…metric object - headersaxis headers, grid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersmetric object - valuesaxis values, grid unit values, all metrics values, report metric values column subtotal values row subtotal valuesaxis - headersgrid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersaxis - valuesgrid unit values, all metrics values, report metric values column subtotal values row subtotal valuesgrid unit - headersall metrics headers, report metric headers, column subtotal headers, row subtotal headersgrid unit - valuesall metrics values, report metric values column subtotal values row subtotal valuesall metrics - headersreport metric headers, column subtotal headersall metrics - valuesreport metric values column subtotal valuesreport metricbanding, column subtotals, row subtotals, thresholdbandingcolumn subtotals, row subtotals, thresholdcolumn subtotalsrow subtotals, thresholdrow subtotalsthresholdreport bordernonethresholdnoneLevelWhat is it?set it here…Notesmetricspecifies a format for a metric regardless of the report it is on.set in the metric editor."all metrics" and "axis" formatting must be set at defaultaxisaffects all units of the axis.format --> rows and columnsgrid unit formatting must be set to defaultgrid unitformatting of individual report items such as attributesgrid units are listed on the Format menu all metricformats the data zone (where the metric values are displayed)format --> all metrics report metricformats an individual metric on a particular reportindividual metrics are listed in the format menu bandingrow or column grouping by colorgrid --> options column subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format -->columns -->subtotal headers or values. to set "grid unit" formatting, select the grid unit from the format menu.row subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format --> rows -->subtotal headers or values. to set "grid unit" formatting, select the ggrid unit from the format menu.overwrites column subtotal formatting where they intersect with row subtotal formattingreport bordercreates a border around the whole reportright-click on the report (but NOT a report object) then select formatting --> report borders thresholdchanges formatting based on returned data.grid --> Thresholdsoverwrites all other layers.Month_IDLast_12_Month200612200612200612200611200612200610200612200609200612200608200612200607200612200606200612200605200612200604200612200603200612200602200612200601200611200611200611200610200611200609200611200608200611200607200611200606200611200605200611200604200611200603200611200602200611200601200611200512......

     
    This layer…is overwritten by these layers…metric object - headersaxis headers, grid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersmetric object - valuesaxis values, grid unit values, all metrics values, report metric values column subtotal values row subtotal valuesaxis - headersgrid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersaxis - valuesgrid unit values, all metrics values, report metric values column subtotal values row subtotal valuesgrid unit - headersall metrics headers, report metric headers, column subtotal headers, row subtotal headersgrid unit - valuesall metrics values, report metric values column subtotal values row subtotal valuesall metrics - headersreport metric headers, column subtotal headersall metrics - valuesreport metric values column subtotal valuesreport metricbanding, column subtotals, row subtotals, thresholdbandingcolumn subtotals, row subtotals, thresholdcolumn subtotalsrow subtotals, thresholdrow subtotalsthresholdreport bordernonethresholdnoneLevelWhat is it?set it here…Notesmetricspecifies a format for a metric regardless of the report it is on.set in the metric editor."all metrics" and "axis" formatting must be set at defaultaxisaffects all units of the axis.format --> rows and columnsgrid unit formatting must be set to defaultgrid unitformatting of individual report items such as attributesgrid units are listed on the Format menu all metricformats the data zone (where the metric values are displayed)format --> all metrics report metricformats an individual metric on a particular reportindividual metrics are listed in the format menu bandingrow or column grouping by colorgrid --> options column subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format -->columns -->subtotal headers or values. to set "grid unit" formatting, select the grid unit from the format menu.row subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format --> rows -->subtotal headers or values. to set "grid unit" formatting, select the ggrid unit from the format menu.overwrites column subtotal formatting where they intersect with row subtotal formattingreport bordercreates a border around the whole reportright-click on the report (but NOT a report object) then select formatting --> report borders thresholdchanges formatting based on returned data.grid --> Thresholdsoverwrites all other layers.Month_IDLast_12_Month200612200612200612200611200612200610200612200609200612200608200612200607200612200606200612200605200612200604200612200603200612200602200612200601200611200611200611200610200611200609200611200608200611200607200611200606200611200605200611200604200611200603200611200602200611200601200611200512......

     
    This layer…is overwritten by these layers…metric object - headersaxis headers, grid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersmetric object - valuesaxis values, grid unit values, all metrics values, report metric values column subtotal values row subtotal valuesaxis - headersgrid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersaxis - valuesgrid unit values, all metrics values, report metric values column subtotal values row subtotal valuesgrid unit - headersall metrics headers, report metric headers, column subtotal headers, row subtotal headersgrid unit - valuesall metrics values, report metric values column subtotal values row subtotal valuesall metrics - headersreport metric headers, column subtotal headersall metrics - valuesreport metric values column subtotal valuesreport metricbanding, column subtotals, row subtotals, thresholdbandingcolumn subtotals, row subtotals, thresholdcolumn subtotalsrow subtotals, thresholdrow subtotalsthresholdreport bordernonethresholdnoneLevelWhat is it?set it here…Notesmetricspecifies a format for a metric regardless of the report it is on.set in the metric editor."all metrics" and "axis" formatting must be set at defaultaxisaffects all units of the axis.format --> rows and columnsgrid unit formatting must be set to defaultgrid unitformatting of individual report items such as attributesgrid units are listed on the Format menu all metricformats the data zone (where the metric values are displayed)format --> all metrics report metricformats an individual metric on a particular reportindividual metrics are listed in the format menu bandingrow or column grouping by colorgrid --> options column subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format -->columns -->subtotal headers or values. to set "grid unit" formatting, select the grid unit from the format menu.row subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format --> rows -->subtotal headers or values. to set "grid unit" formatting, select the ggrid unit from the format menu.overwrites column subtotal formatting where they intersect with row subtotal formattingreport bordercreates a border around the whole reportright-click on the report (but NOT a report object) then select formatting --> report borders thresholdchanges formatting based on returned data.grid --> Thresholdsoverwrites all other layers.Month_IDLast_12_Month200612200612200612200611200612200610200612200609200612200608200612200607200612200606200612200605200612200604200612200603200612200602200612200601200611200611200611200610200611200609200611200608200611200607200611200606200611200605200611200604200611200603200611200602200611200601200611200512......

     
    This layer…is overwritten by these layers…metric object - headersaxis headers, grid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersmetric object - valuesaxis values, grid unit values, all metrics values, report metric values column subtotal values row subtotal valuesaxis - headersgrid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersaxis - valuesgrid unit values, all metrics values, report metric values column subtotal values row subtotal valuesgrid unit - headersall metrics headers, report metric headers, column subtotal headers, row subtotal headersgrid unit - valuesall metrics values, report metric values column subtotal values row subtotal valuesall metrics - headersreport metric headers, column subtotal headersall metrics - valuesreport metric values column subtotal valuesreport metricbanding, column subtotals, row subtotals, thresholdbandingcolumn subtotals, row subtotals, thresholdcolumn subtotalsrow subtotals, thresholdrow subtotalsthresholdreport bordernonethresholdnoneLevelWhat is it?set it here…Notesmetricspecifies a format for a metric regardless of the report it is on.set in the metric editor."all metrics" and "axis" formatting must be set at defaultaxisaffects all units of the axis.format --> rows and columnsgrid unit formatting must be set to defaultgrid unitformatting of individual report items such as attributesgrid units are listed on the Format menu all metricformats the data zone (where the metric values are displayed)format --> all metrics report metricformats an individual metric on a particular reportindividual metrics are listed in the format menu bandingrow or column grouping by colorgrid --> options column subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format -->columns -->subtotal headers or values. to set "grid unit" formatting, select the grid unit from the format menu.row subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format --> rows -->subtotal headers or values. to set "grid unit" formatting, select the ggrid unit from the format menu.overwrites column subtotal formatting where they intersect with row subtotal formattingreport bordercreates a border around the whole reportright-click on the report (but NOT a report object) then select formatting --> report borders thresholdchanges formatting based on returned data.grid --> Thresholdsoverwrites all other layers.Month_IDLast_12_Month200612200612200612200611200612200610200612200609200612200608200612200607200612200606200612200605200612200604200612200603200612200602200612200601200611200611200611200610200611200609200611200608200611200607200611200606200611200605200611200604200611200603200611200602200611200601200611200512......

     
    This layer…is overwritten by these layers…metric object - headersaxis headers, grid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersmetric object - valuesaxis values, grid unit values, all metrics values, report metric values column subtotal values row subtotal valuesaxis - headersgrid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersaxis - valuesgrid unit values, all metrics values, report metric values column subtotal values row subtotal valuesgrid unit - headersall metrics headers, report metric headers, column subtotal headers, row subtotal headersgrid unit - valuesall metrics values, report metric values column subtotal values row subtotal valuesall metrics - headersreport metric headers, column subtotal headersall metrics - valuesreport metric values column subtotal valuesreport metricbanding, column subtotals, row subtotals, thresholdbandingcolumn subtotals, row subtotals, thresholdcolumn subtotalsrow subtotals, thresholdrow subtotalsthresholdreport bordernonethresholdnoneLevelWhat is it?set it here…Notesmetricspecifies a format for a metric regardless of the report it is on.set in the metric editor."all metrics" and "axis" formatting must be set at defaultaxisaffects all units of the axis.format --> rows and columnsgrid unit formatting must be set to defaultgrid unitformatting of individual report items such as attributesgrid units are listed on the Format menu all metricformats the data zone (where the metric values are displayed)format --> all metrics report metricformats an individual metric on a particular reportindividual metrics are listed in the format menu bandingrow or column grouping by colorgrid --> options column subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format -->columns -->subtotal headers or values. to set "grid unit" formatting, select the grid unit from the format menu.row subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format --> rows -->subtotal headers or values. to set "grid unit" formatting, select the ggrid unit from the format menu.overwrites column subtotal formatting where they intersect with row subtotal formattingreport bordercreates a border around the whole reportright-click on the report (but NOT a report object) then select formatting --> report borders thresholdchanges formatting based on returned data.grid --> Thresholdsoverwrites all other layers.Month_IDLast_12_Month200612200612200612200611200612200610200612200609200612200608200612200607200612200606200612200605200612200604200612200603200612200602200612200601200611200611200611200610200611200609200611200608200611200607200611200606200611200605200611200604200611200603200611200602200611200601200611200512......

     
    This layer…is overwritten by these layers…metric object - headersaxis headers, grid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersmetric object - valuesaxis values, grid unit values, all metrics values, report metric values column subtotal values row subtotal valuesaxis - headersgrid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersaxis - valuesgrid unit values, all metrics values, report metric values column subtotal values row subtotal valuesgrid unit - headersall metrics headers, report metric headers, column subtotal headers, row subtotal headersgrid unit - valuesall metrics values, report metric values column subtotal values row subtotal valuesall metrics - headersreport metric headers, column subtotal headersall metrics - valuesreport metric values column subtotal valuesreport metricbanding, column subtotals, row subtotals, thresholdbandingcolumn subtotals, row subtotals, thresholdcolumn subtotalsrow subtotals, thresholdrow subtotalsthresholdreport bordernonethresholdnoneLevelWhat is it?set it here…Notesmetricspecifies a format for a metric regardless of the report it is on.set in the metric editor."all metrics" and "axis" formatting must be set at defaultaxisaffects all units of the axis.format --> rows and columnsgrid unit formatting must be set to defaultgrid unitformatting of individual report items such as attributesgrid units are listed on the Format menu all metricformats the data zone (where the metric values are displayed)format --> all metrics report metricformats an individual metric on a particular reportindividual metrics are listed in the format menu bandingrow or column grouping by colorgrid --> options column subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format -->columns -->subtotal headers or values. to set "grid unit" formatting, select the grid unit from the format menu.row subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format --> rows -->subtotal headers or values. to set "grid unit" formatting, select the ggrid unit from the format menu.overwrites column subtotal formatting where they intersect with row subtotal formattingreport bordercreates a border around the whole reportright-click on the report (but NOT a report object) then select formatting --> report borders thresholdchanges formatting based on returned data.grid --> Thresholdsoverwrites all other layers.Month_IDLast_12_Month200612200612200612200611200612200610200612200609200612200608200612200607200612200606200612200605200612200604200612200603200612200602200612200601200611200611200611200610200611200609200611200608200611200607200611200606200611200605200611200604200611200603200611200602200611200601200611200512......

     
    This layer…is overwritten by these layers…metric object - headersaxis headers, grid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersmetric object - valuesaxis values, grid unit values, all metrics values, report metric values column subtotal values row subtotal valuesaxis - headersgrid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersaxis - valuesgrid unit values, all metrics values, report metric values column subtotal values row subtotal valuesgrid unit - headersall metrics headers, report metric headers, column subtotal headers, row subtotal headersgrid unit - valuesall metrics values, report metric values column subtotal values row subtotal valuesall metrics - headersreport metric headers, column subtotal headersall metrics - valuesreport metric values column subtotal valuesreport metricbanding, column subtotals, row subtotals, thresholdbandingcolumn subtotals, row subtotals, thresholdcolumn subtotalsrow subtotals, thresholdrow subtotalsthresholdreport bordernonethresholdnoneLevelWhat is it?set it here…Notesmetricspecifies a format for a metric regardless of the report it is on.set in the metric editor."all metrics" and "axis" formatting must be set at defaultaxisaffects all units of the axis.format --> rows and columnsgrid unit formatting must be set to defaultgrid unitformatting of individual report items such as attributesgrid units are listed on the Format menu all metricformats the data zone (where the metric values are displayed)format --> all metrics report metricformats an individual metric on a particular reportindividual metrics are listed in the format menu bandingrow or column grouping by colorgrid --> options column subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format -->columns -->subtotal headers or values. to set "grid unit" formatting, select the grid unit from the format menu.row subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format --> rows -->subtotal headers or values. to set "grid unit" formatting, select the ggrid unit from the format menu.overwrites column subtotal formatting where they intersect with row subtotal formattingreport bordercreates a border around the whole reportright-click on the report (but NOT a report object) then select formatting --> report borders thresholdchanges formatting based on returned data.grid --> Thresholdsoverwrites all other layers.Month_IDLast_12_Month200612200612200612200611200612200610200612200609200612200608200612200607200612200606200612200605200612200604200612200603200612200602200612200601200611200611200611200610200611200609200611200608200611200607200611200606200611200605200611200604200611200603200611200602200611200601200611200512......

     
    This layer…is overwritten by these layers…metric object - headersaxis headers, grid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersmetric object - valuesaxis values, grid unit values, all metrics values, report metric values column subtotal values row subtotal valuesaxis - headersgrid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersaxis - valuesgrid unit values, all metrics values, report metric values column subtotal values row subtotal valuesgrid unit - headersall metrics headers, report metric headers, column subtotal headers, row subtotal headersgrid unit - valuesall metrics values, report metric values column subtotal values row subtotal valuesall metrics - headersreport metric headers, column subtotal headersall metrics - valuesreport metric values column subtotal valuesreport metricbanding, column subtotals, row subtotals, thresholdbandingcolumn subtotals, row subtotals, thresholdcolumn subtotalsrow subtotals, thresholdrow subtotalsthresholdreport bordernonethresholdnoneLevelWhat is it?set it here…Notesmetricspecifies a format for a metric regardless of the report it is on.set in the metric editor."all metrics" and "axis" formatting must be set at defaultaxisaffects all units of the axis.format --> rows and columnsgrid unit formatting must be set to defaultgrid unitformatting of individual report items such as attributesgrid units are listed on the Format menu all metricformats the data zone (where the metric values are displayed)format --> all metrics report metricformats an individual metric on a particular reportindividual metrics are listed in the format menu bandingrow or column grouping by colorgrid --> options column subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format -->columns -->subtotal headers or values. to set "grid unit" formatting, select the grid unit from the format menu.row subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format --> rows -->subtotal headers or values. to set "grid unit" formatting, select the ggrid unit from the format menu.overwrites column subtotal formatting where they intersect with row subtotal formattingreport bordercreates a border around the whole reportright-click on the report (but NOT a report object) then select formatting --> report borders thresholdchanges formatting based on returned data.grid --> Thresholdsoverwrites all other layers.Month_IDLast_12_Month200612200612200612200611200612200610200612200609200612200608200612200607200612200606200612200605200612200604200612200603200612200602200612200601200611200611200611200610200611200609200611200608200611200607200611200606200611200605200611200604200611200603200611200602200611200601200611200512......

     
    This layer…is overwritten by these layers…metric object - headersaxis headers, grid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersmetric object - valuesaxis values, grid unit values, all metrics values, report metric values column subtotal values row subtotal valuesaxis - headersgrid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersaxis - valuesgrid unit values, all metrics values, report metric values column subtotal values row subtotal valuesgrid unit - headersall metrics headers, report metric headers, column subtotal headers, row subtotal headersgrid unit - valuesall metrics values, report metric values column subtotal values row subtotal valuesall metrics - headersreport metric headers, column subtotal headersall metrics - valuesreport metric values column subtotal valuesreport metricbanding, column subtotals, row subtotals, thresholdbandingcolumn subtotals, row subtotals, thresholdcolumn subtotalsrow subtotals, thresholdrow subtotalsthresholdreport bordernonethresholdnoneLevelWhat is it?set it here…Notesmetricspecifies a format for a metric regardless of the report it is on.set in the metric editor."all metrics" and "axis" formatting must be set at defaultaxisaffects all units of the axis.format --> rows and columnsgrid unit formatting must be set to defaultgrid unitformatting of individual report items such as attributesgrid units are listed on the Format menu all metricformats the data zone (where the metric values are displayed)format --> all metrics report metricformats an individual metric on a particular reportindividual metrics are listed in the format menu bandingrow or column grouping by colorgrid --> options column subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format -->columns -->subtotal headers or values. to set "grid unit" formatting, select the grid unit from the format menu.row subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format --> rows -->subtotal headers or values. to set "grid unit" formatting, select the ggrid unit from the format menu.overwrites column subtotal formatting where they intersect with row subtotal formattingreport bordercreates a border around the whole reportright-click on the report (but NOT a report object) then select formatting --> report borders thresholdchanges formatting based on returned data.grid --> Thresholdsoverwrites all other layers.Month_IDLast_12_Month200612200612200612200611200612200610200612200609200612200608200612200607200612200606200612200605200612200604200612200603200612200602200612200601200611200611200611200610200611200609200611200608200611200607200611200606200611200605200611200604200611200603200611200602200611200601200611200512......

     
    This layer…is overwritten by these layers…metric object - headersaxis headers, grid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersmetric object - valuesaxis values, grid unit values, all metrics values, report metric values column subtotal values row subtotal valuesaxis - headersgrid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersaxis - valuesgrid unit values, all metrics values, report metric values column subtotal values row subtotal valuesgrid unit - headersall metrics headers, report metric headers, column subtotal headers, row subtotal headersgrid unit - valuesall metrics values, report metric values column subtotal values row subtotal valuesall metrics - headersreport metric headers, column subtotal headersall metrics - valuesreport metric values column subtotal valuesreport metricbanding, column subtotals, row subtotals, thresholdbandingcolumn subtotals, row subtotals, thresholdcolumn subtotalsrow subtotals, thresholdrow subtotalsthresholdreport bordernonethresholdnoneLevelWhat is it?set it here…Notesmetricspecifies a format for a metric regardless of the report it is on.set in the metric editor."all metrics" and "axis" formatting must be set at defaultaxisaffects all units of the axis.format --> rows and columnsgrid unit formatting must be set to defaultgrid unitformatting of individual report items such as attributesgrid units are listed on the Format menu all metricformats the data zone (where the metric values are displayed)format --> all metrics report metricformats an individual metric on a particular reportindividual metrics are listed in the format menu bandingrow or column grouping by colorgrid --> options column subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format -->columns -->subtotal headers or values. to set "grid unit" formatting, select the grid unit from the format menu.row subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format --> rows -->subtotal headers or values. to set "grid unit" formatting, select the ggrid unit from the format menu.overwrites column subtotal formatting where they intersect with row subtotal formattingreport bordercreates a border around the whole reportright-click on the report (but NOT a report object) then select formatting --> report borders thresholdchanges formatting based on returned data.grid --> Thresholdsoverwrites all other layers.Month_IDLast_12_Month200612200612200612200611200612200610200612200609200612200608200612200607200612200606200612200605200612200604200612200603200612200602200612200601200611200611200611200610200611200609200611200608200611200607200611200606200611200605200611200604200611200603200611200602200611200601200611200512......

     
    This layer…is overwritten by these layers…metric object - headersaxis headers, grid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersmetric object - valuesaxis values, grid unit values, all metrics values, report metric values column subtotal values row subtotal valuesaxis - headersgrid unit headers, all metrics headers, report metric headers, column subtotal headers, row subtotal headersaxis - valuesgrid unit values, all metrics values, report metric values column subtotal values row subtotal valuesgrid unit - headersall metrics headers, report metric headers, column subtotal headers, row subtotal headersgrid unit - valuesall metrics values, report metric values column subtotal values row subtotal valuesall metrics - headersreport metric headers, column subtotal headersall metrics - valuesreport metric values column subtotal valuesreport metricbanding, column subtotals, row subtotals, thresholdbandingcolumn subtotals, row subtotals, thresholdcolumn subtotalsrow subtotals, thresholdrow subtotalsthresholdreport bordernonethresholdnoneLevelWhat is it?set it here…Notesmetricspecifies a format for a metric regardless of the report it is on.set in the metric editor."all metrics" and "axis" formatting must be set at defaultaxisaffects all units of the axis.format --> rows and columnsgrid unit formatting must be set to defaultgrid unitformatting of individual report items such as attributesgrid units are listed on the Format menu all metricformats the data zone (where the metric values are displayed)format --> all metrics report metricformats an individual metric on a particular reportindividual metrics are listed in the format menu bandingrow or column grouping by colorgrid --> options column subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format -->columns -->subtotal headers or values. to set "grid unit" formatting, select the grid unit from the format menu.row subtotalscan be applied either as "zone" or "grid unit" formatting. "grid unit" formatting moves with the subtotals while "zone" is based on location.to set "zone" formatting, select format --> rows -->subtotal headers or values. to set "grid unit" formatting, select the ggrid unit from the format menu.overwrites column subtotal formatting where they intersect with row subtotal formattingreport bordercreates a border around the whole reportright-click on the report (but NOT a report object) then select formatting --> report borders thresholdchanges formatting based on returned data.grid --> Thresholdsoverwrites all other layers.Month_IDLast_12_Month200612200612200612200611200612200610200612200609200612200608200612200607200612200606200612200605200612200604200612200603200612200602200612200601200611200611200611200610200611200609200611200608200611200607200611200606200611200605200611200604200611200603200611200602200611200601200611200512......


    and so on for every month in every year.
     
    Note that the column names chosen for this table are deliberate - the existing Month attribute uses the column name 'Month_ID'. So this same column name is chose for the first column in the above table. Also note that the data in the above table is stored in the YYYMM format. The YYYMM format matches the data for the ID attribute form of the Month attribute in the Tutorial project.
     
  • For every month in the first column, Month_ID, there are now 12 months in the second column, Last_12_Month. Note that this is similar to a year-to-month transformation table.
  • Open up Warehouse Catalog and add this new table named 'Last_12_Month_Table' as a source for the project, as shown below:
ka04W000000ObdvQAC_0EM440000002Ewe.jpeg
  • After adding the table to our project, ensure that the Month_ID column was picked up by the existing Month attribute. Since the Strategy Tutorial project has automatic column mapping enabled by default and the same column name as the existing Month ID attribute form was used, the Month attribute has already picked up and added the Last_12_Month_Table as a source table. If not, add the Last_12_Month_Table as a source table for the Month attribute, as shown below:
ka04W000000ObdvQAC_0EM440000002EwT.jpeg
  • Next, create the transformation. Select the Month attribute as the Member Attribute:
ka04W000000ObdvQAC_0EM440000002Ex2.jpeg
  • In the next screen drop down, choose the Last_12_Month_Table and the column as our member attribute expression, as shown below:
ka04W000000ObdvQAC_0EM440000002Ewg.jpeg
  • Lastly, select the transformation mapping type of 'Many to Many.' And save the transformation as 'Last12Months', as shown below:
ka04W000000ObdvQAC_0EM440000002Ewa.jpeg
  • With the architecting steps complete, perform a schema update selecting 'Update schema logical information' in the Strategy Tutorial project, as shown below:
ka04W000000ObdvQAC_0EM440000002EwQ.jpeg
  • Create a metric (Sum(Revenue)) and set the metric transformation to 'Last12Months' as created in step 8, as shown below:
ka04W000000ObdvQAC_0EM440000002Ex4.jpeg
  • Place this metric in a report and run it against a filter that prompts on Month. The report returns data for the last year when prompting for a specific month in a year, as shown below:
ka04W000000ObdvQAC_0EM440000002EwV.jpeg
  • To check this value, the following report was run for the 12 months including and preceding December 2006:
ka04W000000ObdvQAC_0EM440000002Ewc.jpeg

Comment

0 comments

Details

Knowledge Article

Published:

May 22, 2017

Last Updated:

May 22, 2017