Default sorting is available only in the pivot tables with one column selected as row labels. |
Locate the Cell value delimiter box.
Enter the character (multiple characters) used to separate values in cells.
Save the macro and the page.
If the call value delimiter is not a regular character, but a space, use the Unicode character \u0020. |
|
The incorrectly specified decimal separator may cause the incorrect calculation of numerical values. |
Selection of the thousands separator is optional as it only improves Options of numerical values without affecting the original values in the source table. |
Save the macro and the page.
You may need to limit the decimal places when using the Average operation type. |
|
For the details on specifying date formats, read this article. |
The Pivot Table macro supports summarization of worklogs and time intervals.
Please ensure that the worklog parameters set in the macro are identical to parameters configured in Atlassian JIRA. |
Worklog time units in different languages are denoted with different shortenings. Please adjust them according to your JIRA localization settings. |
|
To show/hide the source table in the page view mode:
|
Save the macro and the page.
To hide the control panel in the page view mode:
To show the control panel hove over the pivot table and click the cogwheel icon on the right of the table. |
|
When selecting the Literal operation type the Literal value delimiter option becomes available:
5. Save the macro and the page.
This option can be enabled only if the calculation result is displayed as a table with a single cell. |