Pivot table sorting with month_id and average column in BI publisher temp
In my project we are using the Oracle BI analysis for creating reports in BI publisher.
At first we are creating the report in OBIEE answers then using it as data model in BI Pub.
My reporting table holds data like below:
Month_Name Year Month_Id Compensation Emp ID
JAN 2011 1000 50 1234
FEB 2011 1001 60 1235
We need to show the data in pivot format i.e period(concated month+year) in column and comepsation values as measure and emp id in rows.I also need to show percentage i.e sum(Compensation/no of selected of periods).
For average in OBIEE pivot i have create one calulated item. But I can't sort the data(for periods with the month_id) as its spillting the average column also.
How can i sort it? like JAN2011 FEB2011 MAR2011 in pivot
also in BI pub this calculated item not showing correct value.
Please help.