I am having a probem with my sql. I want to create a formula for my pivot field.. here is my code...
FROM CO09_Report REPORT
INNER JOIN TBLTYPES TYPES
ON REPORT.MATERIAL = SUBSTRING(TYPES.TXTMATERIAL,13,18)
--WHERE REPORT.Custom_ATP_Quantity > 0
FOR [TYPE] IN ([IN TRANSIT], [HAULAGE], [PRODUCTION]))
my problem is that how can i multiply REPORT.Haulage_In_Transit to [IN TRANSIT] that is located in the pivot
can anyone has an idea about this..?
You could always create a temp table to hold the results of your pivot, then join that back to your original table...if I understand what you're asking for, that is.
anyways, i already done this, i just inserted another select at the top of the queries from thier i created the formula.
thanks BitBit for suggestion..