Reg: Pivot Table Grand total hide — Oracle Analytics

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

Reg: Pivot Table Grand total hide

Received Response
21
Views
3
Comments
User_JZKI6
User_JZKI6 Rank 4 - Community Specialist
edited Aug 13, 2024 5:23PM in Oracle Analytics Cloud and Server

Hi All,

In the below Pivot table view we could see that grand total of all sub regions.

pastedImage_0.png

We are trying to hide the Grand Total like below can some suggest on this.

pastedImage_1.png

Thanks,

Answers

  • Joel
    Joel Rank 8 - Analytics Strategist

    Firstly, are you just trying to hide the grand total text? Secondly, your grand total sums up to 70. Shouldn't it sum up to 60?

    If you're just trying to hide the Grand Total text, then in the Pivot Table properties, for the measure, edit the measure labels as below and in the caption, just add a space.

    pastedImage_0.png

  • User_JZKI6
    User_JZKI6 Rank 4 - Community Specialist

    Thanks Joel its working.

  • Joel
    Joel Rank 8 - Analytics Strategist

    Great. If your issue is resolved with the information that was provided above then mark as correct to help others in the community who may have this issue in the future.