Jump 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.

Export sub-summary's to excel?

meglome
in Importing & Exporting

Featured Replies

I'm doing a favour for a friend and I'm really pulling my hair out. I need to export a report to excel which contains sub-summary's sorted by date. It's a list of dates with totals which I can view on screen, print or export to pdf. However all I can get in excel is a list of dates with a grand total next to the first date. I must be missing something. Any help appreciated.

See if this helps:

http://fmforums.com/forum/showtopic.php?tid/212491/post/346682/#346682

  • Author

Thanks for your reply.

If I understand this correctly if I want to do the following (with the totals being sub-summary's by date) and get it into excel:

Date Amount

Jan 20.00

Feb 10.00

Mar 15.00

I can't do this, I need to use xml?

Cause as I mention above right now the best I can get is:

Date Amount

Jan 45.00

Feb

Mar

  • Author

Thank you so much for your help. Not sure I would have ever figured that our myself.

Create an account or sign in to comment

https://fmforums.com/topic/70789-export-sub-summarys-to-excel/
Go to topic listing

Important Information

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

I accept

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.