Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 77 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
grand total issue in obiee
hi,
I have a requirement to show the grand total for only few values and for some values we don't need to show grand total. for ex,we have the report format as below :-
emp table :-
emp name emp no salary
A 132 23,000
B 452 10,000
C 103 6,000
so the output should look like
emp name emp no salary
A 132 23,000
A total 132 23000
B 452 10,000
C 103 6,000
C total 103 6,000
if we can say from above we can only see the total for A,C Value but not for B. please help me for how we can achieve above requirement.
Answers
-
Something as random as that is probably best done using calculated items.
0 -
but if I use calculated items and I have ine more column after emp name say emp id if I use total of that emp name its repeating for all the emp id
0 -
As they say "You have to die one death or another".
What you're asking has nothing to do with analytics but just GUI tricks / trying to be Excel.
All of this is better done in BIP and not a dynamically rendering analytics tool.
0