Answers: Table/Pivot Sum and group

Muhammad Jahanzaib

Hi,

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

   

Purchase Order No	PO Amount	MRN No	Amount
100025688	100800	100128613	25000
	100800	100130060	25400
100025688 Total	100800		50400

Note: Po Amount Aggregation Rule is SUM

How can I achieve this.

Thanks,

JB

Gianni Ceresa

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 ...

Andrew Fomin.

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.

Muhammad Jahanzaib

Thanks. It helped.