As, per your requirements You can following below steps that can useful for you.
1]. Calculate Base_SALE.
2]. Calculate NEW_SALES=SALE / BASE_SALE.
3]. Give filter interaction between slider(date), First List Table (Base_SALE) and second List Table(date, NEW_SALES).
But here you have to select FILTER TYPE in interaction between slider and second List table is BRUSH.
So, it will give all date and if you select Slider date then it will also effect in second list table but their is blue color row see. that is your selected date in slider and other date is shown as a white color rows.
As per your reference see the all capture in attached file.
As I understand you want to be able to dynamicaly filter the period of base sale and then show the calculated new sales based on this number. The problem here is that the new sales can not use the same date filter as the base sales.
I think there is a solution but is not very straight forward. I don't have the time now to give a comprehensive answer but I think following steps would work:
- Instead of the timeslider use two drop down listboxes (date from, date to) and connect them to 2 parameters.
- Don't use interactions from these 2 drop-down listboxes.
- Create a new calculated item to filter the base sales using the 2 parameter values (using if then else)
- use the new calculated item in the aggregated measure to calculate new sales.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.