Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be use a calculated expression for the multibox:
Aggr(Only({<Stcode = >} Product), Product)
Thanks Sunny for the Prompt response,
above expression it is not working.
Regards,
John
Would you be able to share the sample application you are working with?
PFA.
Thanks
John