Pivot App - How can filter a field

Hi there, I'm new using the Pivot App and I was wondering if there is a way to filter any of the fields in the pivot table.

I have an excel pivot table that I'm trying to replicate in smartsheet from a master data that already is imported into my smartsheet. There is a column in the data master named "Current Status" with 5 different options (active, closed, pending closure, etc.), in this case I only want to show in the smartsheet pivot table "active" counts

Any suggestion is appreciated!

Find more posts tagged with

Reports

Integrations

functionality

Accepted answers

Kelly Moore

Hello

In addition to using a sheet as the Pivot App source, one can use Reports. As one possible solution, create the filter you desire in a Report, then create the Pivot from there.

All comments

Kelly Moore

Hello

In addition to using a sheet as the Pivot App source, one can use Reports. As one possible solution, create the filter you desire in a Report, then create the Pivot from there.

Xochitl Cerda

Thanks so much @KDM ! great idea!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.