1 Reply Latest reply on May 1, 2018 5:05 PM by Hari Ankem

# To use single selection filter in stead of parameter

Info:

TY: This Year

LY: Last Year

Fields we have:

• Week,
• Year,
• Sales

Requirement:

• TY Sales
• LY Sales
• Variance%

Selections:

• From Week:
• To Week:

Calculations:

• TY = Range of      ”From week”   to   “To Week”

Example:    From week = 1/2015  and   To Week= 15/2017

Then TY = range of 1/2015 to 15/2017

• LY = Range from 1/2014 to 15/2016  (just year-1 with respect to the from week and to week selection)
• TY Sales : Sales in TY
• LY Sales : Sales in LY
• Variance% : (TY Sales-LY Sales)/(TY Sales)

Note : I have implemented the logic using Parameter(From Week, To Week) but I am not getting variance% correctly . And since parameters are not dynamic please help me to implement the same logic using single selection filter (From Week, To Week).

• ###### 1. Re: To use single selection filter in stead of parameter

Here is a solution:

1. Join the data with itself as shown below. The join calculation you see on the left derives the Week LY. So, the data you get from the sheet on the right is the sales for LY.

2. Create the following calculated fields:

3. You can use the Week TY - Date as a filter and display the data as given below.

Hope this helps. A 10.5 workbook is attached.