How to aggregate this table?

Stefano_Mazzocca · Feb 19, 2025 5:28PM

I have this table:

Column C counts 1 when A = B and all these 3 are custom metrics.

Is there a way to make an aggregate view with only columns D, E and C? If we make a pivot or modify col C metric with "SUM" all the values are the same for each D or E value

Sumanth V -Oracle · Feb 19, 2025 5:56PM

@Stefano_Mazzocca -

Instead of SUM( C) , use COUNT(A) FILTER (WHERE A = B) to ensure proper aggregation.

This ensures that C is counted only when A=B.

Hope this helps!

Oracle Fusion Data Intelligence

Categories

How to aggregate this table?

Best Answer