Chart question

[feflorio]

I have a table like this:

Product A -> 100
Product B -> 50
Product C -> 60

I want to do a column chart with this information, but I need to have an aditional data like the medium value (eg:70),but BO create a column for each product, and I want that it was like a tendence line.

Any idea ?

Thanks.

 

[blom0344]

Hello Feflorio,

Create a report variable XXXX which is defined as :

=Average(<measure>) in Product

*** measure is the column with 100,50,60 , product is dimension column ******

and set this in your graph , go to Format graph --> tab series. Add a new group and assign the new report variable to this group. Set group type as line. T. Blom
Information analist
Shimano Europe
tbl@shimano-eu.com

 

[feflorio]

Thank you, Blom, it´s the right way.

Fábio.