Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 34 Oracle Analytics and AI Sharing Center
- 22 Oracle Analytics and AI Lounge
- 276 Oracle Analytics and AI News
- 47 Oracle Analytics and AI Videos
- 16.1K Oracle Analytics and AI Forums
- 6.3K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 99 Oracle Analytics and AI Trainings
- 16 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Need to display the totals of a column seperately
3174977
Rank 5 - Community Champion
Hi All,
I have a report with columns type(Actual/plan) & hours. Currently we are displaying the grand total of all hours (Actual & Plan). But the users wanted to see grand total of actual and plan hours separately. is that possible if so how can we achieve this. Please see the below ,

Is there any way to separate the grand total for actual and plan..
Thanks !
0
Answers
-
Hello,
Yes its possible, use a "pivot table" graph:
1. put your "type" column

2. your mesure
in this section3, Set up your rows, sum total by rows

Kind Regards
0 -
Thank you
0