
Announcements
Hi all,
I have this collection and would like to filter base on selected condition.
Below is my collection table:
| Order# | Product# | Size | Quantity |
| 1 | Product A | Small | 2 |
| 1 | Product A | Large | 5 |
| 1 | Product B | Small | 2 |
| 2 | Product B | Small | 2 |
| 2 | Product A | Large | 4 |
| 1 | Product B | Large | 5 |
When there is a dropdown selection made on Product: Product A and Size: Large on the gallery,
Filter the same criteria in the the collection and sum the quantity.
The end result would be for ; Collection, Product A, Large, 9
Need your advice on how the statement should be written in this scenario.
Thanks in advance for the help.
Regards
Hidayat
Insert a Textbox and on Default property;
Sum(Filter(Datasource Product = Dropdown1.Selected.Value And Size =
Dropdown2.Selected.Value), Quantity)
------------
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.