Radar chart question

[APB1981]

Hello,

MSSQL CR XI r1

I have a question regarding radar charts and grouping in general.

I want to create a group in CR that shows all items then 2 additional groups for Item A and Item B. When I create a formula for this it seems to display all items in ALL group and does not include the remaining two groups. I need these groups because I have a radar chart. I need to display average for all and for the two groups so you can see a comparison.

Any ideas....

Formula for group:

if {ITEM.GROUP_Object_Id} > 1 then "Company Average"
else
if {ITEM.GROUP_Object_Id} = {?Pm-ITEM.GROUP_Object_Id} then "Group A"
else
if {ITEM.GROUP_Object_Id} = {?Pm-@share group B} then "Group B"

APB

 

[APB1981]

Thought I would clarify what I am looking for here:

One group to show all items, item A and item B...

So the group will have 3 entries and data below each group.

The reason for this is I want a radar chart to compare company average to item and item b....

Thanks

APB

 

[lbass]

Your formula won't work, since an if-then formula evaluates sequentially, and:

1) if a record meets the criteria of an initial clause, it will be not be evaluated against later clauses.

2) one record can appear only in one group.

I think what you need here is a trendline for the average, not a separate "group."

-LB