Categories
- All Categories
- Oracle Analytics Learning Hub
- 30 Oracle Analytics Sharing Center
- 20 Oracle Analytics Lounge
- 250 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16.1K Oracle Analytics Forums
- 6.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 92 Oracle Analytics Trainings
- 16 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
BI Publisher 12C: How to set aggregation for each measure on Pivot Table in RTF Template
Summary
BI Publisher 12C: How to set aggregation for each measure on Pivot Table in RTF Template
Content
I have 3 measures that are PRODUCT_QTY,UNIT_COST and TOTAL_COST.
I want to set aggregation for PRODUCT_QTY to sum, UNIT_COST to average and TOTAL_COST to sum.
But when I double click at C to edit code. It appears like this:
I don't know how to set aggregation for each measure because it has only one sum.
Answers
-
You could change aggregation with xdoxslt functions like xdoxslt:maximum. Take a look a this blog, it might be helpful https://blogs.oracle.com/xmlpublisher/minning-and-maxing-in-pivots
0 -
i try to set aggregation as you suggest but i don't know why it doesn't work.
<?crosstab:c66450;"//G_1";"PRODUCT_GROUP{,o=a,t=t},PRODUCT_TYPE{,o=a,t=t},PRODUCT_SUB_TYPE{,o=a,t=t},PRODUCT_LINE{,o=a,t=t},PRODUCT_FULL_NAME{,o=a,t=t}";"TXT_MEASURE_NAME{,o=a,t=t}";"PRODUCT_QTY";"sum";
"UNIT_COST";"xdoxslt:maximum";
"TOTAL_COST";"sum"?>
<?crosstab:c66450;"//G_1";"PRODUCT_GROUP{,o=a,t=t},PRODUCT_TYPE{,o=a,t=t},PRODUCT_SUB_TYPE{,o=a,t=t},PRODUCT_LINE{,o=a,t=t},PRODUCT_FULL_NAME{,o=a,t=t}";"TXT_MEASURE_NAME{,o=a,t=t}";"PRODUCT_QTY,UNIT_COST,TOTAL_COST";"sum,xdoxslt:maximum,sum"?>
<?crosstab:c66450;"//G_1";"PRODUCT_GROUP{,o=a,t=t},PRODUCT_TYPE{,o=a,t=t},PRODUCT_SUB_TYPE{,o=a,t=t},PRODUCT_LINE{,o=a,t=t},PRODUCT_FULL_NAME{,o=a,t=t}";"TXT_MEASURE_NAME{,o=a,t=t}";"PRODUCT_QTY,UNIT_COST,TOTAL_COST";"sum";"xdoxslt:maximum";"sum"?>
how to set?
Thx.
0