Register to the Data Intelligence Summit Mexico City Register today to the Oracle Analytics Data Intelligence Summit in Mexico City on April 8th
Oracle Analytics was named as a Leader Oracle Analytics was named as a Leader in the 2024 Gartner® Magic Quadrant for Analytics and BI Platforms
New Oracle Analytics Release March 2025 New Oracle Analytics March 2025 release for Oracle Analytics Cloud and Analytics Server
Oracle Analytics Product Satisfaction Survey Share your experience and satisfaction with Oracle Analytics Product with our Product Satisfaction Survey

Welcome to the Oracle Analytics Community

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Comments

Update: This particular column uses a DFF. Seemingly we can't use SUMMATION on DFFs. We have tried CAST as well but it didn't help. Thanks, Aloka

in Is it possible to use SUM on a column where COUNT(DISTINCT(column) ) is used? Comment by Aloka Bhattacharya September 2018
Thanks Wade!! Let me check that. Aloka

in Is it possible to use SUM on a column where COUNT(DISTINCT(column) ) is used? Comment by Aloka Bhattacharya September 2018
Its a regular table Wade. Can you share a sample of the pivot? It would be good to learn that! Thanks, Aloka

in Is it possible to use SUM on a column where COUNT(DISTINCT(column) ) is used? Comment by Aloka Bhattacharya September 2018