Dear Gurus,
I am creating a pivot table with Average aggregate function,
It has 7-questions(render as column header above data labels) which will rate (represents data value) by some n-committee members (represented as row header). I am generating average based on row header and column header, Row-average is generating as expected but column average is showing the average for every column, but I want the average of last aggregated average column only.
And when I am using aggregate function the data values are changing from integer to float, My requirement is just to display integer value not decimal and average should be round value to max.
Please help me to achieve the same, let me know if there is any work around.
I am using Jdeveloper 11.1.2.4
Please find my query
select member_id, notes, session_papers_fk, evaluation_ref_fk, rate,EVALUATION_DESC, FULL_NAME, eval_member_master_fk,DECISION, eval_note,DECISION_DESC,DECISION_FL
from (
select c.committee_member_fk member_id, b.notes, b.rate, b.evaluation_ref_fk, a.session_papers_fk, D.EVALUATION_DESC, e.FULL_NAME, B.EVAL_MEMBER_MASTER_FK, b.DECISION, A.EVAL_NOTE,f.DECISION_DESC,A.DECISION_FL
from mgz_eval_member_master a, mgz_eval_member_child b, mgz_committee_session_member c, MGZ_EVALUATION_REF d, ta_user e, decision_detail f
where 1=1
and b.eval_member_master_fk = a.eval_member_master_pk
and a.committee_member_fk = c.session_member_pk
and D.EVALUATION_REF_PK = B.EVALUATION_REF_FK
and c.committee_member_fk = e.user_id
and A.DECISION_FL = f.DECISION_ID
)
where 1=1
and session_papers_fk = :p_session_paper_fk
member_id, decision_desc render as Row header and Evaluation_desc as column header and rate as data value.
Shown my requirement in below image.
