No. I believe, when you create a report or pivot table in Confluence, it asks for which all columns you want and therefore it can't be defined in JIRA. You can only fetch data from JIRA, but you need to select or define what all columns you want, in Confluence.
Suppose a field in JIRA "Approval Category" has values : QA Pass, Requirement, UAT Pass, Test Plan.
I am using the Pivot Table in Confluence and would like to use the following order "Requirement, QA Pass, UAT Pass and Test Plan". Is it possible ? I need help with the SQL Query..
Secondly, is it possible to hide a portion of the column header in SQL?