Forum Discussion
Dynamic filtering
Hi, I was wondering if I can apply a dynamic filter in Desktop. A table (directly to SQL Server OLTP DB) has column [Year] (= transactional year) and I added custom column [CurrYear] to that rec...
fbrossard
Kudo Commander
Kudo CommanderHi bijntjede2e
You could enrich your date table by adding a calculated column for relative year
Relative Year = INT(YEAR([Date]) - YEAR(TODAY()))
and use it as filter onto your report, page or visual.and select the values according to the scope you want to analyze, in your example 0,-1,-2.