Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to display the agent field for transactions for this year and previous year.
How can I solve this?
What is agent field? Please provide some sample data.
Vinay
Pls could elaborate more on what is the agent field & where do you want to display ?
Hi,
Current year <Year = {"$(=max(Year))"}>
Previous year <Year = {"$(=max(Year)-1)"}>
the agent field contains the agent of that particular transaction and i want to display of this year and of the last year to check whether it changed or not
the agent field contains the agent of that particular transaction and i want to display of this year and of the last year to check whether it changed or not
the agent field contains the agent of that particular transaction and i want to display of this year and of the last year to check whether it changed or not
Hi,
Please see below might be helpful...
Load * inline
[yr,sale
2010,200
2011,100
2013,50
2014,40
]
;
Current year expression
sum({<yr= {'$(=year(Today()))'}>}sale)
Previous month expression
sum({<yr= {'$(=year(Today())-1)'}>}sale)
Regards
Vinay
I think we need to understand your data model. From your description above it reads like a transaction last for many years and can have many agents over that time. I suspect that is not the case. Is there a customer/account in the model as well that links the transactions together?
i have a table that have transactions throughout the years and each transaction is associated with a particular agent .. so i want to make a table so that when i choose a particular year a table that contains the client details and the agent of this year and the agent of the previous year for each transaction is displayed. So that i can identify those records that changed agent