MultiBox

[#1]

Hi All,

I have Country,Item,Product,Stcode,Sales,Purchase as fields

i have a multi box with Country, Item.Product, list box with Stcode and a Pivot table with Item, Product, Sales, Purchase.

Here for the Product field in multibox i am getting 7 records, but in the chart i am getting 13 products For the Country Selection UK and Stcode 0.

because I have used Sum({<Stcode=>}Purchase), due to this product values are not in sync between Chart and MultiBox, so how can i show the 13 values in the multibox Product field.

Load Script:

Directory;

LOAD Country,

     Item,

     Product,

     Stcode,

     Sales

FROM

Book1.xlsx

(ooxml, embedded labels, table is Sheet1);

Directory;

LOAD Country,

     Item,

     Product,

     Num(Purchase,'#,##0') AS Purchase

FROM

Book1.xlsx

(ooxml, embedded labels, table is Sheet2);

Purchaseexpression: sum({<Stcode=>}Purchase)

Sals Expression: Sum(Sales)

can any one help me on this.

Thank you!

John

[sunny_talwar]

May be use a calculated expression for the multibox:

Aggr(Only({<Stcode = >} Product), Product)

[#3]

Thanks Sunny for the Prompt response,

above expression it is not working.

Regards,

John

[sunny_talwar]

Would you be able to share the sample application you are working with?

[#5]

PFA.

Thanks

John