Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Date Prompt Issue
- Thread starter MSTRtec
- Start date
Why would you want to select a 'previous year' based on the year you choose. Instead choose the previous year itself.
But if you want to select all years before the selected year, go to your filter and use an attribute qualification where the yearID is set to filter out all years lesser than the ID of the year selected.
You can also use transformations.
But if you want to select all years before the selected year, go to your filter and use an attribute qualification where the yearID is set to filter out all years lesser than the ID of the year selected.
You can also use transformations.
entaroadun
Programmer
Are you calculating the previous year for just some metrics and not others? What exactly are you getting at?
- Status
Similar threads
- Locked
- Question