Oracle BI - RTF Template - How to add subtotals
Hello,
I am trying to create a BI report using RTF Template.
I have the following column records, including different examples:
ACCOUNT - CECO 1 - CECO 2 - PROJECT - AMOUNT
34XXX1 - Example1 - 1111 - Project1 - 2000
34XXX1 - Example1 - 1222 - Project1 - 2000
34XXX1 - Example1 - 1222 - Project1 - 3000
34XXX1 - Example2 - 2111 - Project1 - 2000
34XXX1 - Example2 - 2222 - Project2 - 2000
I need to create a Subtotal with CECO 1 - CECO 2 and PROJECT combination. In this way, I need the following result:
ACCOUNT - CECO 1 - CECO 2 - PROJECT - AMOUNT
34XXX1 - Example1 - 1111 - Project1 - 2000
I am trying to create a BI report using RTF Template.
I have the following column records, including different examples:
ACCOUNT - CECO 1 - CECO 2 - PROJECT - AMOUNT
34XXX1 - Example1 - 1111 - Project1 - 2000
34XXX1 - Example1 - 1222 - Project1 - 2000
34XXX1 - Example1 - 1222 - Project1 - 3000
34XXX1 - Example2 - 2111 - Project1 - 2000
34XXX1 - Example2 - 2222 - Project2 - 2000
I need to create a Subtotal with CECO 1 - CECO 2 and PROJECT combination. In this way, I need the following result:
ACCOUNT - CECO 1 - CECO 2 - PROJECT - AMOUNT
34XXX1 - Example1 - 1111 - Project1 - 2000
Tagged:
0