Forum Discussion

seakins's avatar
seakins
Data Storage
10-21-2021

Building a pivot table with TY vs LY with % growth

In a pivot table where I have the year 2021 data showing, how can I show the previous years sales (depending on which year has been selected from the main dashboard) including a % growth in the follo...
dashboards & reporting
Finance Analytics
HamzaJ's avatar
HamzaJ
Data Integration
10-21-2021

Hi seakins ,

You mean something like this?

including percentage

Sisense has a quick function for this. Add and duplicate the field representing sales. Click on the three dots and select quick functions:

It will automatically change if you filter on a different year