Forum Discussion

sshweky's avatar
sshweky
Icon for Helper III rankHelper III
10 years ago

Previous Years vs Current Year

Hi,   I want to compare current year's sales vs last year's sales. I am not 100% clear on how time intelligence features work.   I have a "Years" that has the year, year beginning date & year end...
Hikmer's avatar
Hikmer
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

The issue I am facing is similar to this post, if I add a filter for year thne I no longer see a year over year percentage calcualtion.  I beleive I need the previous year to still be exposed while still allowing for the visualization to "slice" on the year but not filter on the year so that previous year data can be calcualted.  See below

 

 

 

michellemetzger's avatar
michellemetzger
New Member
8 years ago

Hello Hikmer,

 

It appears that you may have set the Subtotal value for the year to not show.  Check your Visualization properties.

 

Also, please post your function and full screenshot of the report page so that we can get a better idea of what you are working with.

 

Thanks!