Aligning Columns in Custom Pivot Grid Widgets

When working with custom pivot grid widgets, aligning columns to enhance readability and presentation is a common task. Proper alignment of columns can be achieved through the widget properties section. Here’s how you can align columns in your custom pivot grid widget:

Step-by-Step Column Alignment

1. Download the custom widget: Obtain the ** Pivot Grid Custom Widget** with a custom widget file from the attachment provided.

2. Access Widget Properties: Navigate to the widget properties section of your custom pivot grid widget.

3. Specify Column Name: In the Column Name text box, input the name of the column or its values that you wish to align.

4. Adjust Alignment: Use the dropdown menus to select the desired alignment for the header and text of the specified column. The available alignment options are typically left, right, or center.

Examples of Column Alignment Conditions

• Column Name: Asia

  • If “Asia” is a column value representing a region, setting the header alignment will not have an effect. However, if the text alignment is set to “Center,” the content of this column will be centered.

• Column Name: Bhutan

  • For a sub-level such as “Bhutan” under “Asia,” the column name should be entered as “Asia-Bhutan.” As this is a value under the Country column, header alignment is not applicable. Setting the text alignment to “Center” will center the content within this column.

• Column Name: Total Cost

  • For a sub-level like “Total Cost” under “Asia” and “Bhutan,” the column name should be “Asia-Bhutan-Total Cost.” Since this is an actual column name, you can set the header text alignment to “Center” and the text alignment to “Left” to achieve the desired presentation.

Visual Reference

It is often helpful to refer to visual aids when configuring settings. Please consult any provided images or diagrams that illustrate the alignment settings for further clarification.

Conclusion

Aligning columns in a custom pivot grid widget is a straightforward process that can significantly improve the visual appeal of your data presentation. By following the steps outlined above and considering the examples provided, you can effectively align columns to meet your specific needs.

For more detailed information on custom pivot grid widgets and their properties, please refer to the official documentation or support resources provided by the widget’s developer or vendor.

Additional References

• How to Add a PivotGrid with KPI Widget in Bold BI