Additional grid properties

In a “Design” tab of a Grid dashboard element the following toolbar is available:

• Horizontal Lines – show horizontal grid lines;
• Vertical Lines – show vertical grid lines;
• Banded Rows – banded rows are not supported when cell merging is enabled;

• Merge Cells – merge adjacent cells with identical data (“Drill Down” has to be off);

• Column Header – show column headers;
• Word Wrap;
• Filter Row – the filter row allows a user to filter data by individual column values

When the filter row appears, a user can enter the condition in the text box to filter column values:

• Update Totals – a user can configure a Grid item to reflect changes in column values and recalculate totals based on the applied column filters:

• AutoFit to Contents;
• AutoFit to Grid;
• Manual – adjust the width of columns

By clicking a grid title, the following functionality will be available:

• Fit to Content – fit the column width to its content;
• Fit Width – specify the column width and fix it;
• Column Width – specify the fixed column width;
• Add Format Rule – possibility to choose one of the formatting ways form a dropdown list;
• Edit Rules – possibility to change the existing highlighting rules;
• Clear Rules – deletion of all the highlighting rules;
• Add Total – possibility to display:

• Clear Totals– delete all

Let’s display the minimum and maximum value of the “Reseller Sales Amount” measure in our grid: