Report filter not working properly
Hi,
I'm not sure if there is an inherent filter mechanism as part of Smart Sheet reports but I am trying to use the report filter function to only show rows for specific information.
Column 1 - list of products (e.g. apple, orange, grapes .. etc)
Column 2 - list of groups that buys the product (e.g. group 1, group 2, group 3)
Assumptions:
1) Each row in column 1 is unique
2) Multiple group in column 2 can be associated with each of column 1 but not vice versa (e.g. group 1 may buy both apple and orange but apple will not be bought by both group 1 and 3)
3) There may be blanks in column 2 (e.g. no group buys the product)
Based on the column setting and assumptions, I've applied a filter to see what products I have and what group has made a purchase (filter by contain "group), my result in column 2 shows blanks and groups as if it was not filtered. Question here is, what may be causing this? Is it a sequence of the way Smartsheet filters data or is it something I am doing wrong?
Irene
Comments
-
irene—
Reports are a way to view information from one or more sheets in an aggregated area. They will bring in all rows that meet the criteria, and currently don't perform any sort of pivot to condense the data.
The criteria that you set in the report builder of your report gets pulled in, including any blank cells.
If you're looking for a pivot of the data, check out our pivot app: https://help.smartsheet.com/articles/2476736-get-started-pivot
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!