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?
If you are Summing again in Pivot which means no point of using RSUM.
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?
I mean to say SIGMA or aggregation as you pointed with RED arrow
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.
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.
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?
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:
@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.
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.
This is what I did, I changed the default to Sum
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
Hello Oracle Analytics Community, We are investigating a dashboard compatibility issue between Oracle Analytics Server (OAS) 7.6 and OAS 7.0. Some dashboards originally created in Oracle BI 12c can be opened in OAS 7.6 but fail to open after being archived and imported into OAS 7.0. During our investigation, we found the…
Hi all, We’re running into an issue with an on-premises Oracle Analytics Server 2026 integrated with Active Directory and hoping someone has seen this or knows if a patch is available. Environment: Oracle Analytics Server 2026 (on-premises) WebLogic 14.1.2.0.0, JDK 21, Oracle Linux DB-backed catalog (Oracle DB, BIPLATFORM…
We have a requirement Creating a Bar graph using Cost Center Tree hierarchy as prompt/filter. Created a Bar Graph using Cost Center Tree Hierarchy as a prompt. When I'm selecting values through selection steps from Cost Center Tree Hierarchy, the Bar Graph not refreshing as the selected values are not passing to Graph…
I have 2 tabs on the workbook that use the same dataset. I would rather not use 2 different datasets. Can I code an expression filter or something to remove those records?
Can you please help resolve this error. WebLogic version is 12c. OAS is 6.4