I have a table that lists release against product. One release can include multiple products. I want to get the total number of releases. But the count that I get in pivot table is the total number of rows (i.e. total number of products shipped).
1) How to display the count of releases as 2, coz I have only 2 releases Rel-A and Rel-B ??
2) In the below table, how can I change the header "Count" to "Product Count" ?
For the first case use the following settings for your Pivot Table macro:
To change your headers, wrap your Pivot Table macro into the Table Transformer macro and apply your custom SQL query:
SELECT T1.'Release' AS 'My Release',
T1.'Count' AS 'Count of My Releases'
Hope this helps.
Thanks @Katerina Kovriga _Stiltsoft_ , for the reply.
#1 ) But, it still doesn't give the "count of releases". As you can see I have 2 releases only (Rel-A and Rel-B). How do I get to display the count of releases "2"? The pivot table shows "4" which is actually the total number of products in releases Rel-A and Rel-B combined.
Hello Confluence Community! What if i told you that you could have a healthier life and be 100% meet-less? This month, we're promoting a healthy, balanced work diet with Confluence. We la...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events