Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Below is my load script:
APInvoicePriceVariancebySupplierVendor:
load
C1 AS QtyInvoiced
,C2 AS InvoicePrice
,C3 AS BasePrice
,C4 AS LineNumcount
,C5 AS Currency
,C6 AS EntryType
,C7 AS InvoiceDate
,Date(C7, 'YYYY') AS Year
,C8 AS InvoiceNum
,C9 AS ItemDescription
,C10 AS LineNum
,C11 AS Location
,C12 AS PoNumberRelease
,C13 AS Unit
,C14 AS Vendor,
Date(C7, 'MMM-YYYY') as Invoice_Date,
C15 as InvoicePeriod;
In the straight table, i have taken one dimension "Year" and expression is Sum(InvoicePrice).
The table is displaying duplicate Year values.
I want to aggregate the Invoice Price by Year value. I do not want to see duplicate Year values.
Please do the needful.
Don't format your date values as years, create year values:
,Date(C7, 'YYYY') AS Year
Instead, use
Year(C7) as Year
Thank You Stefan, it is working fine with your solution