Multi Values in BO ver 4 Webb

building reports webintelligence legacy
1

I have a report that returns the following

brand vintage price, for each brand there are multiple vintages and prices so:-

brand vintage rrp
x 2007 30
x 2008 25
x 2009 15

I need the report to show
Brand Vintage rrp
x 2009 15
I have created a max() object and an object for rrp([RRP]ForEach([_Max Vintage] )) I am reveiving a muli value error against the rrp ( the max(,vintage>) works ok. Any ideas how to resolve this.

boyce01 (BOB member since 2010-04-20)

2

Hello fellow BO users,

I have a similar issue, so I am posting it here, in hope for solutions from all of you.

My BO WebI report contains these info:

[list]Product;Supplier;Quantity
1;A;10
2;A;20
2;B;25
3;A;10
3;B;15
3;C;20
4;C;30
4;D;40
[/list]
I would like to build a new variable in the query so that I get only 1 single value per Product, showing the Supplier who has the maximum Quantity, such as this:

[list]Product;SupplierMax;QuantityMax
1;A;10
2;B;25
3;C;20
4;D;40[/list]

or just this:
[list]Product;SupplierMax
1;A
2;B
3;C
4;D[/list]

Many thanks in advance!

imavnio (BOB member since 2014-03-26)