Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

RSUM

Received Response
231
Views
10
Comments
Joe Choueiri-Oracle
Joe Choueiri-Oracle Rank 5 - Community Champion
edited August 13 in Oracle Analytics Cloud and Server

I have applied RSUM by Geo which works fine but for some reason when I add the grand total on the row the total is incorrect, it shows only the sum of NAMER as the grand total- see image below.

Any idea?

pastedImage_0.png

Answers

  • SriniVEERAVALLI
    SriniVEERAVALLI Rank 6 - Analytics Lead

    If you are Summing again in Pivot which means no point of using RSUM.

  • Joe Choueiri-Oracle
    Joe Choueiri-Oracle Rank 5 - Community Champion

    I am not summing again in pivot, do you suggest I dont edit the formula and sum it in pivot? how should I do that?

  • SriniVEERAVALLI
    SriniVEERAVALLI Rank 6 - Analytics Lead

    I mean to say SIGMA or aggregation as you pointed with RED arrow

  • Joe Choueiri-Oracle
    Joe Choueiri-Oracle Rank 5 - Community Champion

    My RSUM is to aggregate the revenue week over week by region as you see in my image for the entire quarter but then I need to show the total for all regions for each week.

  • SriniVEERAVALLI
    SriniVEERAVALLI Rank 6 - Analytics Lead

    Can you try the same steps what you did in Pivot table without RSUM? I think you'll understand after that.

    If not helping! thank you for your time.

  • Joe Choueiri-Oracle
    Joe Choueiri-Oracle Rank 5 - Community Champion

    Thanks again but I want to be able to show the number aggregated week after week for each region, that is why I need it to be RSUM and at the same time I want to show the grant total for each week- so that is not possible?

  • Christian Berg-0racle
    Christian Berg-0racle Rank 10 - Analytics Guru

    Short answer: No.

    Longer answer: No because you define one aggregation rule for totals and not multiple - i.e. one for rows and one for columns:

    pastedImage_2.png

  • Joe Choueiri-Oracle
    Joe Choueiri-Oracle Rank 5 - Community Champion

    @Christian, did you mean to say that I can have only one of the two? and not both? by rows and columns?

    yes I have the RSUM aggregated formula by region in there to show week over week.

  • Christian Berg-0racle
    Christian Berg-0racle Rank 10 - Analytics Guru

    I mean to say that the tool does precisely what I put in the screenshot: it has one aggregation rule which you can set for the totals.

    Now a pivot being a cross-tab that logic will be used for columns and rows. For your RSUM example that means one will be "wrong" but normally an RSUM isn't aggregated again anyways. That's what you have normal measure column for.

  • Joe Choueiri-Oracle
    Joe Choueiri-Oracle Rank 5 - Community Champion

    This is what I did, I changed the default to Sum

    pastedImage_0.png

    Then added total to the rows but removed the total from the columns...so it seems you are right, I think my boss would like more to see the total by columns , we will see. thanks

    pastedImage_1.png