MicroStrategy ONE
Banding
While this is not a tab on the Format dialog box, banding is enabled by default for the following autostyles:
- Accounting
- Finance
- Colorful
- Greybands
Banding is accessed by selecting Options from the Grid menu.
The merge header cells option, on the Grid menu, is set to false on the autostyles listed above. This option allows element names to be repeated for a unit displayed on a row of a report. For example, Country and Region are displayed on the row axis of a report. If merge header cells is set to true, the report displays as:
Country |
Region |
USA |
Northwest |
|
Northeast |
|
South |
Germany |
Saxony |
|
Bavaria |
If merge header cells is set to false, then the report looks like the following:
Country |
Region |
USA |
Northwest |
USA |
Northeast |
USA |
South |
Germany |
Saxony |
Germany |
Bavaria |