Answers: Table/Pivot Sum and group

Question

Hi,

I am using OBIEE 10g, In Answers, I want to achieve as shown in below table:

Purchase Order NoPO AmountMRN NoAmount1000256881008001001286132500010080010013006025400100025688 Total10080050400

Note: Po Amount Aggregation Rule is SUM

How can I achieve this.

Thanks,

JB

Muhammad Jahanzaib · Answer

Thanks. It helped.

Andrew Fomin. · Answer

Actually, the question is: what is the problem?

This report looks pretty usual for me, and some comments are required on what do you have now and what do you want to achieve.

Gianni Ceresa · Answer

Ideally you must correct your model to have the PO Amount with the double meaning: measure in your fact table with a SUM aggregation and in the same time also an attribute without any aggregation (a degenerated dimension exposing the PO Amount as attribute).

Plan B you can change the aggregation to Average, it's probably enough to look like it's what you want ...