Report Pundit
WelcomeStart Free Trial
  • โœจWelcome to Report Pundit Documentation
  • ๐ŸกReport Pundit Website
  • ๐Ÿ’ปReport Pundit App
  • ๐Ÿ›’Shopify Testimonials
  • ๐Ÿ“ŒGetting Started
    • ๐Ÿ‘จโ€๐ŸซWalkthrough
    • โ„น๏ธNavigation Panel
    • ๐Ÿ Home
    • ๐Ÿ“”Library
    • ๐Ÿ’ผMy Reports
    • โฐSchedules
    • โš™๏ธSettings
      • ๐ŸชชAccount
      • ๐Ÿ”Data Sync Options
      • ๐Ÿ› ๏ธReport Formatting
        • ๐Ÿ“…Week Start from Sunday
        • ๐ŸŒ•Include Current Day
        • ๐Ÿ’ฒEnable Currency for Reports
      • ๐Ÿ“€FTP, Google Drive, and Google Sheets
      • ๐ŸŒ€Recent Sync History
      • ๐Ÿ“ฌCustom Email
      • ๐Ÿ‘ฅUser Management
      • ๐Ÿคตโ€โ™‚๏ธShopify staff
    • ๐ŸงฉHow to Create a Custom Report and Auto-Schedule It
  • ๐Ÿง Knowledge Base
    • ๐ŸงพReport Creation
      • Customized Reports
        • Re-arrange columns
      • Filters
        • 'Contains' & 'Not contains'
        • 'Is' & 'Is not'
        • 'Include' & 'Exclude'
        • 'is Blank' & 'is not Blank'
        • 'begins with' & 'ends with'
        • '= Equals' & '!= Not Equals'
        • '> Greater than' & '< Lesser than'
        • '>= Greater than or equal' & '<= Lesser than or equal'
      • Sort
      • ๐Ÿ–Œ๏ธCustom Fields
        • Calculated Columns (Fields)
        • ๐Ÿ›ก๏ธStatic Field
      • Data Comparison
      • Formatting Tools
      • Sharing Report Links
      • Exporting the report
      • Unique Reports
      • Staff Details
      • Other Options
    • ๐Ÿ”—App Integrations
      • Stocky
      • UpPromote
      • Yotpo
      • Sezzle
      • Square
      • PayPal
      • Google Analytics 4
      • Amazon Ads
      • Bing Ads (Microsoft Ads)
      • Facebook
      • Snapchat
      • TikTok
      • Ship Bob
      • Ship Station
      • Ship Hero
      • Bold
      • Printful
      • Printavo
      • Authorize.net
      • Recharge Payments
      • Klarna
      • Shippo
      • Returnly
      • Rich Returns
      • Seal Subscriptions
      • Google Ads
      • Stripe
    • ๐Ÿ“ฅSchedules
      • โŒšHourly
        • "N" Number of Days
        • Week to Date
        • Static Start Date
        • Custom Date Range
      • ๐ŸŒžDaily
        • Custom Time Range
        • Custom Date Range
        • Static Start Date
        • Year to Date
        • Quarter to Date
        • Month to Date
        • Week to Date
        • "N" Number of Days
      • ๐Ÿ“†Weekly
        • Year to Date
        • Quarter to Date
        • Month to date
        • "N" Number of Days
        • Static start date
        • Custom Date Range
      • ๐Ÿ—“๏ธMonthly
        • "N" Number of Days
        • Quarter to Date
        • Year to Date
        • Static Start Date
        • Custom Date Range
      • ๐Ÿ•žSchedule Modification
      • ๐Ÿ”ฝOutput Options
        • Email
        • ๐Ÿ“คFTP
        • ๐Ÿ’ฝGoogle Drive
        • ๐Ÿ—’๏ธGoogle Sheets
        • Power BI
        • BigQuery
    • ๐Ÿ“ƒReport Types
      • ๐ŸคตSales
      • ๐ŸฅกOrders
      • Inventory
      • ๐ŸŽFulfilment
      • Customer
    • ๐Ÿ”„Data Synchronization
      • How to Manage Your Data Mismatch Issue
  • โ“FAQ
    • Reports
    • Schedules
    • Data Sync
    • Billing & Sales
    • Service
  • ๐Ÿ“‹Changelog
Powered by GitBook
On this page
  1. Knowledge Base
  2. Report Creation
  3. Filters

'Include' & 'Exclude'

Previous'Is' & 'Is not'Next'is Blank' & 'is not Blank'

Last updated 2 years ago

How does 'Include' and 'Exclude' filters work?

The Include filter is used to add more than one filter condition.

For example, if you want to filter two product titles, "Airbus Scale model" and "Airplane Painted Vintage", among other product titles, you can apply this filter condition.

When the filter is applied, the report will filter out all the product titles except "Airbus Scale model" and "Airplane Painted Vintage" and displays them.

The Exclude filter is used to eliminate more than one filter condition.

For example, the Exclude filter condition will filter out "Airbus Scale model" and "Airplane Painted Vintage" and show the remaining product titles.

When the filter is applied, the report will filter out all the product titles except "Airbus Scale model" and "Airplane Painted Vintage" and doesn't show them.

๐Ÿง 
๐Ÿงพ