Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can any one help me to create link between Quota and SalesOrderHeader Table and alos tell me how to convert quarter quota into monthly quota. In Quota excel, 275 to 290 are SalesPerson ID and date is Quartely.
and Desired Output is in desired output excel
Please stop cluttering this site with duplicate discussions
As I told you before in How to show Sale Vs Quota there is no relation between the sales persons and the sales orders.
But the data is provided in the same this manner only. Then tell me how is possible that quota can not be linked with table. Sorry to say but i have to find the way to make it linked with table.
The information does not exist in the source data. So there is no way. Unless your willing to present lies as results. In that case create a SalesPersonID field in the SalesOrderHeader table:
LOAD *, Ciel(Rand()*11)+274 as SalesPersonID FROM SalesOrderHeader.qvd (qvd);
And create a SalesPersonID field as well in the load statement that load the quotes data:
CrossTable(SalesPersonID,Quotes,2)
LOAD
F1 as QuarterStart,
Website,
[275],
[276],
[277],
[279],
[280],
[282],
[284],
[286],
[288],
[289],
[290]
FROM
[quota.xlsx] (ooxml, embedded labels, table is Sheet1)
;
That will link your tables. And all based on completely fabricated nonsense.