Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends,..
I have following columns in my code....
OrderID,
CustomerID,
ShipperID,
EmployeeID,
Freight,
OrderDate,
ProductID,
UnitPrice,
OrderID,
Quantity,
Discount,
Categories:
LOAD CategoryID,
CategoryName,
Description
FROM
[$(vQvdPath)Categories.qvd]
(qvd);
Customers:
LOAD CustomerID,
CompanyName,
ContactName,
Address,
City,
StateProvince,
PostalCode,
Country,
Phone,
Fax
FROM
[$(vQvdPath)Customers.qvd]
(qvd);
Employee:
LOAD EmployeeID,
[Last Name],
[First Name],
Title,
[Hire Date],
Office,
Extension,
[Reports To],
[Year Salary]
FROM
[$(vQvdPath)Employee.qvd]
(qvd);
Office:
LOAD Office,
OfficeAddress,
OfficePostalCode,
OfficeCity,
OfficeStateProvince,
OfficePhone,
OfficeFax,
OfficeCountry
FROM
[$(vQvdPath)Office.qvd]
(qvd);
Products:
LOAD ProductID,
ProductName,
SupplierID,
CategoryID,
QuantityPerUnit,
UnitCost,
Prod_UnitPrice,
UnitsInStock,
UnitsOnOrder
FROM
[$(vQvdPath)Products.qvd]
(qvd);
Shippers:
LOAD ShipperID,
Shipper_CompanyName
FROM
[$(vQvdPath)Shippers.qvd]
(qvd);
MasterCalendar:
Right Keep (Orders)
LOAD
OrderDate,
Week,
Year,
Month,
MonthNo,
DayofYear,
MonthYear,
YearMonth,
Day,
Quarter,
YearWeek,
WeekDay,
WeekDayNo,
WeekInMonth,
CurYTDFlag,
LastYTDFlag,
CurMTDFlag,
LastMTDFlag
FROM
[$(vQvdPath)MasterCalendar.qvd]
(qvd) Where Year>=($(vMaxYear)-2);
...
i need logic for following Fields...
1)Sales
2)Margin
3)Margin%
4)Gross Sales
6)Gross Sales For specific Year
7)Net Sales
😎Net Sales for specific Year
9) Sales Rep
10)Cost
Thanks
venky
huh ?
sorry your request is not clear, you want to know how to calculate those metrics ?
that is something I would go back to internal team and not try to get a generic answer on how to do it
Ya i need those Mertrics..
they gave as
Gross Sales = [UnitPrice] * [Quantity]
Net Sales = ([UnitPrice] * [Quantity]) * (1-Discount)
But about remaining metrics??