BI Publisher 12C: How to set aggregation for each measure on Pivot Table in RTF Template

3023281

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.

Sherry George

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

3023281

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.