Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Community,
I have scatter chart like following, with table besides as comparison, with both expression of sales are same as below, but you can see for same category of item, the sales amount are different with the scatter chart result being over 25M, and table result to be over 16 M only. Any expert can give me some hint on this? thanks!
Sum({<[Order Type]={'Y400','Y410'},Order_Responsible_Person-={'GF'},FiscalYear_Orderinv={"$(='>='&'2018')"}>}Aggr(Order_Total_Value_Net_Local_Curreny,[Order No.],[Item Number]))
For scatter chart, the expressions of bubble dimension are as following, with tables' dimensions you can see from picture as fiscalyear, fiscalmonth, ordertype, category, customer name etc.
If(Order_Material_Pricing_Group_Text='spare parts' or Order_Material_Pricing_Group_Text='service' or Order_Material_Pricing_Group_Text='repair works' or
Order_Material_Pricing_Group_Text='grinding media', If(Subsidiary<>'Subsidiary', Order_Material_Pricing_Group_Text,'IC'&'/'&Order_Material_Pricing_Group_Text))