This discussion is archived
0 Replies Latest reply: Apr 7, 2012 8:20 AM by 929098 RSS

Aggregation on calculated measures in pivot table in obiee11g

929098 Newbie
Currently Being Moderated
HI,

I have a requirement wherein a top 20 customer list has to be displayed for a measure (Export%based on sellin )for 13 weeks chosen.After displaying the 13 weeks measure for all customers,i have to aggregate these into a single value for each customer and thereby rank them.

The aggregation of these 13 values into single value is not working out and also unable to apply topN function over it.


Could someone pl help me over this.
It would be v helpful...
Thanks:)

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points