How to show current year data only

[balasundaram]

I have designed dashboard.in my reports i have current and previous data.But while open report i want current year data. if i selected previous year in list box i want to get previous data in same report. Please provide any expression like that..

[sushil353]

hi,

You can create a trigger on open of document.. Select in field> =Year(now())

HTH

Sushil

[deepakqlikview_123]

Hi U can save report after selection of current year.so that when user open the report in accesspopint he will get current years data.

Thanks,

[ashfaq_haseeb]

Like this

Current Year Sales

=Sum({<Year = {'$(=Max(Year))'}>} Sales)

or

=Sum({<Year = {"$(vCurrYr)"}>} Sales)

Previous Year Sales

=Sum({<Year = {'$(=Max(Year)-1)'}>} Sales)

or

=Sum({<Year = {"$(vPrevYr)"}>} Sales)

ASHFAQ

[#5]

Please find the attached file may this will help you.

this is done by trigger    

[vardhancse]

we can select the current year in the list box and make the list box as always one selected value.

Then by default current selected year will be default in the dashboard.

And we can create trigger->on open document-clear all.

So that every time we open the dashboard, by default the year will be current.

[balasundaram]

i coudnt get attached file

[balasundaram]

=Sum({<Year = {'$(=Max(Year))'}>} Sales)

its working separate selections only like

while opening its showing current year data,in list box if i selected previous year its showing previous data..but issue is if i selected both previous and current year in list box..its showing only current year...not showing total two year data..

how to solve this issue??

[ashfaq_haseeb]

=Sum({$<Year = P(Year>} Sales)

Will gives you both year.

Make sure to close thread, if it answered

Regards

ASHFAQ

[balasundaram]

not working