Categories
- All Categories
- Oracle Analytics Learning Hub
- 19 Oracle Analytics Sharing Center
- 18 Oracle Analytics Lounge
- 232 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.9K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 86 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Custom Group calculation isn't subtotaling in pivot table
JessT
Rank 1 - Community Starter
My Group calculation of JE Classification is working fine to group things together, but the subtotal function is bringing back the first value instead of summing it. The Group calculation is set as Text type, but i don't see any method to change that, and really it is text. Any way I can get this to display with a summed subtotal?
0
Best Answer
-
Thanks Daniel! As an FDI newbie I did not find that panel easily, but that was the fix. Appreciate the help!
0
Answers
-
Always check the obvious things first. On the properties tab of the grammar panel for this visual, is the aggregation for this measure set to Auto? Can you change it to SUM?
0