Hi Everyone,
I am looking for a feature to get the options to retain the value of a parameter in my dashboard. I have a Pivot table in the below format
where
Starting headcount = for first month, its the value from database, and for the following months , its the previous Month’s Baseline headcount.
Hires= By default its the value from database. But user can input the ires for different months at same time. ie, If the user selected update only selected month option and select multiple months from the filter , then enter a value in Hires control, then that value will get populate to selected months. remaining months it will show the database value.
Terms= same for terms as well. but whatever value we enter in terms, in table it will appear as negative. because terms is negative. we need to deduct terms in calculation
Baseline headcount= This is the sum of (starting headcount+ Hires)-Terms
Now I have a enhancement request, for updating Different different values for Hires and Terms for different months. ie, If user want to update hires 10 for 2024-10 and 20 for 2024-12 etc etc,.Ie, the same parameter have to retain its value in the visual and do the calculation based on that. I checked for this functionality, but its saying that quicksight cannot retain the value of a parameter, and an alternate approach is to create a temporary table in the backend and join it with dataset for user input.
can anyone suggest if I can achieve this functionality in any of the ways without creating multiple parameters for holding the value of each month in detail?