Oracle Analytics and AI

Donna Fazio

I created a simple pivot table to count the number of accounts in a certain category. It is doing a distinct count and adding the totals at the end. What could possibly be causing the miscalculation?

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/26652/pivot-table-incorrect-total

Hi @Donna Fazio,

Welcome to the Oracle Analytics Community!

Can you please check if the 'Aggregation Rule' has been set for the column in the Pivot table?

Here is an example.

Hope this help.

Thank you.