Dimension is displaying duplicate values

[Prabhu]

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.

[swuehl]

Don't format your date values as years, create year values:

,Date(C7, 'YYYY') AS Year

Instead, use

Year(C7) as Year

[Prabhu]

Thank You Stefan, it is working fine with your solution