Filter a gallery with multiple dropboxes

[OsmandFernando]

Hi, 

I have a Gallery and 3 drobboxes as follows, 

1. Item
2. Year
3. Month

At the moment the behaviour is,

• If the Item box is blank I see the entire collection
• If I select and Item, then I need to select the year and month to see the Item and Total qty in the Gallery

What I want is, 

• When the Item box is blank I should see all the items with total qty (like I have now)
• Then Item, Year and month (above 2nd bullet) 
• Also the I select the year I want to see the Items and Total qty for the selected year, then when I select the Year and Month I want to see the Items and total Qty for the selected year and month

Following is the current formula I have, 

If(IsBlank(ComboBox3.Selected),SumIssuesbyItemSpec,Filter(
SumIssuesbyItemSpec,
IsEmpty(ComboBox3.Selected)=true Or Itemspec = ComboBox3.Selected.'Item and Spec',
IsEmpty(ComboBox3_1.Selected)=true Or Issued_x0020_Month = ComboBox3_1.Selected.Value,
IsEmpty(ComboBox3_2.Selected)=true Or Text(Value(Issued_x0020_Year),"[$-en-US]###") = Text(ComboBox3_2.Selected.Value)))

Screenshot, 

Osmand

[Drrickryp · Accepted solution]

Hi @OsmandFernando 

Check out @Shanescows video https://www.youtube.com/watch?v=kLGglidmPxg .  It will show you how to do it.

[eka24]

Try:

Filter(
SumIssuesbyItemSpec,
'Item and Spec'= ComboBox3_1.Selected Or

 Issued_x0020_Month = ComboBox3_2.Selected Or,
Issued_x0020_Year = ComboBox3_2.Selected)

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[OsmandFernando]

Thank you @Drrickryp  @eka24