hello. How would I create a slice that only d...

[Gerald_Kariuki]

hello. How would I create a slice that only displays unique values from a column eg as categories. for instance, material types from a col of several instances of material? I would like to add to this the total of each category. Thanks

[Harry2]

@Gerald_Kariuki Hi Gerald, if you want to create a view that displays categories as well as aggregate statistics for each category, such as category total, then I think a slice is not the most optimal option. Have you tried using Groupby? You can learn more about this in the article below:

help.appsheet.com - Controlling Grouping Controlling Grouping help.appsheet.com