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.

Consolidating Values

iThink
in Charting

Featured Replies

Hi,

I am attempting to create a pie chart in a table (expenses), utilizing a field (company) from a related table (expense account), and utilizing the expense amount total field in the (expenses) table as the value.

I'm assuming I need some sort of calculation to consolidate these companies and the expense amount values.

Simply plugging in the 2 fields displays every expense transaction record, rather than displaying a consolidated grouping of companies and their related expense amount totals.

Also, I'm attempting to create a bar chart that utilizes the transaction date 00/00/0000 in the (expense) table and convert it to a month in the chart, while displaying the expense amount totals associated with their respective "month" transaction dates.

Any ideas on the best way to achieve this?

Thanks!

Create an account or sign in to comment

https://fmforums.com/topic/71647-consolidating-values/
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.