Skip to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Exporting Single records of Grouped Data

Joel Saltzman
in Importing & Exporting

Featured Replies

I have a report run on all the line items of products that have sold. It gourps the data together in the preview mode to show the total number of each unique item sold. When I export the info it exports like I were browsing the records. I mean each line item shows how many times it was sold and not the total.

Example:

Part: 1234 Name:Widget QTYSOLD:1

Part: 1234 Name:Widget QTYSOLD:1

Part: 1234 Name:Widget QTYSOLD:1

Part: 5678 Name:MYWidget QTYSOLD:1

Part: 5678 Name:MYWidget QTYSOLD:1

Instead of:

Part: 1234 Name:Widget QTYSOLD:3

Part: 5678 Name:MYWidget QTYSOLD:2

Any Ideas?

First, you need a summary field, defined as Total of QTYSOLD.

Then specify your export to group by Part.

---

Note that you have to sort by Part before exporting.

Edited by Guest

  • 2 weeks later...
  • Author

AH HA, thanks!

Create an account or sign in to comment
Go to topic listing

Important Information

By using this site, you agree to our Terms of Use.

I accept

Account

Navigation

Search

Search

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.