How to count unique values

Question

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" ?

Katerina Kovriga {Stiltsoft} · Answer

For such case you should use the Table Transformer macro:

SELECT
COUNT (DISTINCT (T1.'Release')) AS 'Number of releases'
FROM T*

emagnun · Answer

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.

Katerina Kovriga {Stiltsoft} · Answer

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.