Total of column — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Total of column

Received Response
1
Views
2
Comments
3193829
3193829 Rank 5 - Community Champion

Hi,

I have column (eg:Sales), which is not aggregated in the rpd and should not be aggregated. It is just shown across a dimension column. But i have requirement where i have to do a total of the column across a static text. (like sales : 5000). when i am using sum over it for aggregation i am getting junk values. is there any way i can get the column total.

Thanks,

Kalpana

Answers

  • SriniVEERAVALLI
    SriniVEERAVALLI Rank 6 - Analytics Lead

    In the rpd go with 2 columns 1 for Sales which goes to dimension and other one is for sum(sales) which is for Facts in Presentation

    in the report use accordingly

  • cesar.advincula.o
    cesar.advincula.o Rank 6 - Analytics Lead

    Umm do you want the total sales in a row of your table? or a column or your table? dont understand well your requirement.

    1. However, if you want a calculation in a row:

    -Please edit your view and in the View you could and set up you "Aggregation Rule"

    C1.png

    2. However, if you want a calculation TOTAL in a Colum:


    Create a column in your criteria section, and apply this formula: "sum( YouMeasure by "Sales")


    Hope this help.


    Kind Regards,