Hi@vikna,
Based on the issue that you mentioned, do you want to create a summary table that display the quantity of different tabs?
Could you please tell me that if you have classified these products into different categories?
I see that you need to display the products into different categories, like laptops, keyboards, monitors. If you want to display data by this product category, you must have these products classified?
In my scenario, I classify all the products into different categories. I have another table named Category which is used to display all the products into different categories.
I have a test on my side, please take a try as below.
I create a collection to summarize all the tables as below:
Collect(
CIOlSummary,
AddColumns(
TableSummary,
"Cate",
LookUp(
TableCategory,
ProductName = Products,
Category
),
"SumQuantity",
Sum(
KOTMAM,
KULMS,
LUT
)
)
)
And then you could add 3 Galleries to display all the products into different categories based on the Dropdown selected.
Add 3 Dropdowns and set the Items property as below:
Distinct(TableCategory,Category)
Note: TableCategory is a table named Category which is used to display all the products into different categories.
Set the first Gallery Items property as below to display all the Laptops:
Filter(CIOlSummary,Cate=LaptopDropdown.Selected.Result)
Set the Text property of the Label within as below:
"SumQuatity is:"&ThisItem.SumQuantity
You can repeat the above for the Keyboards and Monitors categories.
Please check the GIF fore reference.
Regards,
Qi
