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
Hi,
Thank you for your question. Looking at this discussion, I do see the need of comparing data from this year to the data of a previous year - Where a previous year might not necessarily be the last one.
I'd recommend a few things:
1. Assuming you are working according to best practices, you should have a date dimension you're using to filter your dates. If you don't, please create one (you can use the following one we've created (https://support.sisense.com/kb/en/article/date-dimension-file)
2. Create a custom table (say: "YearCompare") including a single column (year) with two rows (representing the years you wish to compare)
3. Connect the year column to the date dimension's "Year" column
4. Create a pivot table using the following structure:
4.a. Rows - The branch/country/person (or any other category you'd like to aggregate according to)
4.b. Values - Add 3 values:
4.b.i. A measured value representing year #1 - For example: (SUM(Revenue),<Date Filter>) - Where the filter is on min of "YearCompare"
4.b.ii. A measured value representing year #2 - For example: (SUM(Revenue),<Date Filter>) - Where the filter is on max of "YearCompare"
4.b.ii. A measured value representing growth - For example: (SUM(Revenue),<Date Filter (Max Year)>) / (SUM(Revenue),<Date Filter (Min Year)>)
4.c. Columns - Keep empty
Please also note that you can also change the columns' location by changing the row order (dragging the up or down)
I hope this helps,
Ophir
