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" ?
Hi @emagnun ,
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'
FROM T*
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
For such case you should use the Table Transformer macro:
SELECT
COUNT (DISTINCT (T1.'Release')) AS 'Number of releases'
FROM T*
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.