BusinessObjects Board

How can display subtotals in report area

building reports desktopintelligence
#1

Hi
in my report i need to display subtotals like
report colum
----------------
for example= pencils= 2
pens= 3
pencils =1
pens= 2
total pencil = 4
total pens= 5
-------
total= 9

can i create any varialble . how can i do this , pl tell me very urgent
thank you

santhil (BOB member since 2004-09-26)

#2

Do you have an object that contains values like “Pencils” and “Pens” or you have two objects one each for Pencils and Pens?

Please use Code for the output so that it is easier for us to understand.

Please avoid using the word “Urgent”. It will not help you getting a quick reply and resolution.

Kashif

Kashif Saeed :pakistan: (BOB member since 2004-06-02)

#3

Please, look at the Reporter functions similar to:

= SUM(<Measure>) WHERE (<ProductType> = "Pencil" )

For more information take a look at the Reporter FAQ here.

Andreas :de: (BOB member since 2002-06-20)