grand total issue in obiee

3167974

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.

[Deleted User]

Something as random as that is probably best done using calculated items.

3167974

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

[Deleted User]

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.