Grand total of subtotals — Oracle Analytics

Oracle Analytics Cloud and Server

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

Grand total of subtotals

Received Response
2
Views
1
Comments
mmajdana1
mmajdana1 Rank 6 - Analytics Lead

Hi I am using OBI 12.2.1.2.0

Can someone tell me how to add grandtotal of subtotal to pivot view, i have a subtotals by stores  where i count how many products are sold on my analysis

but i want to have a grandtotal of all stores , I dont see option for that

Thx, Matija

Answers

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    Like this?

    pastedImage_0.png

    If so, achieved by ticking totals after for Accounting Year and then totals after for rows (the sigma tick)

    pastedImage_1.png

    pastedImage_2.png