Getting the All Year the Same data in all years

[#1]

Hi community members,

I have taken sum(sales) as expression and year as dimension and getting the sum(sales) equal for all the years,can anyone correct me, what is the problem

[MayilVahanan]

Hi

Can you provide a sample file? Its useful for us to find the solution

[#3]

I have mentioned the sheet as year wise sheetproblem name.please go through it and reply me

[MayilVahanan · Accepted solution]

HI

There is no link between years and sales.So only it display like that

[v_iyyappan]

Hi,

    Which field u r using join the date and treat qvd.

Iyyappan.

[#6]

how to link the sales to invoice table of theAcctInvoice.Can you please give me a hint

[MayilVahanan]

Hi

Use Year(InvoiceDate) as Year . I think that helps