# Filter data based on multiple Parameter value selection

**URL:** <https://community.amazonquick.com/t/filter-data-based-on-multiple-parameter-value-selection/17265>\
**Category:** Q&A\
**Tags:** parameters, filters, quick-sight\
**Created:** [August 22, 2023, 12:41am UTC](https://community.amazonquick.com/t/filter-data-based-on-multiple-parameter-value-selection/17265 "2023-08-22T00:41:29Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![karanchhabra99](https://avatars.discourse-cdn.com/v4/letter/k/3bc359/32.png) [@karanchhabra99](https://community.amazonquick.com/u/karanchhabra99)\
**Post date:** [August 22, 2023, 12:41am UTC](https://community.amazonquick.com/t/filter-data-based-on-multiple-parameter-value-selection/17265/1 "2023-08-22T00:41:29Z")

</div>

Hi Team,  
I have a parameter (type _list_) name **reporting\_granularity** which has values → Daily, Weekly, Monthly. Additionally, I have a calculated field **total** which is a calculated field, below is the formula,

`ifelse( in('Daily', ${reporting_granularity}, part1, in('Weekly', ${reporting_granularity}, part2, in('Monthly', ${reporting_granularity}, part3, 0 )`

I want user to be able to select all three parameter values and **total** to show aggregation of all 3 → part1 + part2 + part3. But based on the currently formula I am only being able to do it for only one value.

One way I discover to solve it is use _and_ statements, but I don’t find it efficient and it is highly prone to errors. Is there any alternative way?

---

<div class="post-metadata">

**Author:** ![sagmukhe](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/sagmukhe/32/22033_2.png) [@sagmukhe](https://community.amazonquick.com/u/sagmukhe)\
**Post date:** [August 22, 2023, 6:57am UTC](https://community.amazonquick.com/t/filter-data-based-on-multiple-parameter-value-selection/17265/2 "2023-08-22T06:57:00Z")

</div>

Hello @karanchhabra99 - Thank you for posting your query. I have tried to simulate the scenario at my end and I believe I was able to work it out provide my understanding is correct. Can you please go through the below steps and let me know if this is what you are looking for? Hope this helps!

Step 1 : Sharing the Sample Dataset Details below which I have considered to work out the scenario.

![image](https://d1wl4jav5dp96l.cloudfront.net/original/2X/d/db98cc6f6891af6fe629ab8ee7456118f8650d4e.png)

Step 2 : Create a Parameter with the following details

 ![image](https://d1wl4jav5dp96l.cloudfront.net/original/2X/8/8f0be7183c79747db414949c25a7f44993266142.png)

Step 3 : Create a Calculated Field

![image](https://d1wl4jav5dp96l.cloudfront.net/original/2X/0/0b656c0beff02f3f1ad64241798b1f0834e3326e.png)

Step 4 : Sample Executions for various parameter selection

 ![image](https://d1wl4jav5dp96l.cloudfront.net/original/2X/2/223fd43c87fc0622e98d36835506cd080a677df0.png)

_Did my suggestion help you in resolving your query? If yes, would request you to mark the post as “Solution”. This will help the community to find guidance and answers to similar question. Thank you!_
