6 Replies Latest reply on Mar 26, 2019 3:30 AM by MANOJ PRABHAKAR

# How to find % of difference between current year total and previous year total for custom measures?

How to find % of difference between current year total and previous year total for custom measures?

• ###### 1. Re: How to find % of difference between current year total and previous year total for custom measures?

Can you attach a sample workbook to highlight your issue?

Why would the "Percent Difference" Quick Table Calc not work?

• ###### 2. Re: How to find % of difference between current year total and previous year total for custom measures?

ok here is an sample image of the original report.

My Original Requirement is little complex to duplicate as an workbook.

I have a total of 50 + different measures for an ivr self service monthly report.

we have to show the calls for all the months of the current year (which we are able to do).

in the next tab near to December we have to show the total for the current year for all the 50+ rows (which is easy with the inbuilt function)

the next tab should show the Calls for the year minus one the current year.

(this we did by simply duplicating the sheet and selecting the previous year from the filter. but this method is not applicable to real time right, as once we have published to the server, the reports should dynamically open for the current year.)

this is where we are struggling) how to dynamically set the filter to minus one year for the previous year total (needed for all the 50 rows)

and the last tab should show the % Change from previous year to the current year (needed for all the 50 rows).

I need  formulas to calculate the previous year total and % change and also what kind of date range filter should be used here

for this kind of monthly self service report (an year filter or an date picker or any date parameter)

• ###### 3. Re: How to find % of difference between current year total and previous year total for custom measures?

I was able do this.But it doesn't satisfy my requirements

• ###### 4. Re: How to find % of difference between current year total and previous year total for custom measures?

What you could do is to build measures for Jan - Dec, and then 3 measures for your total columns

I have attached an example based on the superstore dataset which then looks like the following. Would that work?

1 of 1 people found this helpful
• ###### 5. Re: How to find % of difference between current year total and previous year total for custom measures?

Thank you, For YTD Previous this worked for me.

YTD Previous = IF YEAR([Date Range]) = [Year Filter] - 1 THEN [Attempts] END

• ###### 6. Re: How to find % of difference between current year total and previous year total for custom measures?

How to show up,down and equal indicators as well before/after the % Change Tab?