Categories
- All Categories
- Oracle Analytics Learning Hub
- 19 Oracle Analytics Sharing Center
- 17 Oracle Analytics Lounge
- 233 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.9K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 87 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations 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