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.

Report design - how to make a summary look more like a table

Featured Replies

  • Newbies

I've tried to find a solution and must not be searching for the correct terms.

My boss wants a statistical report that gives him an idea of how many people are renewing their software subscription and how long they go without renewing. I've created a field called Expired Status (text) that puts each customer into the proper category. I know how to get the totals if I use subsummaries sorted by the different categories. But the format isn't conducive to taking it to the next level that he wants.

He wants a bar graph of the numbers for each product and for the totals. This report that I've made to get the numbers isn't something that can easily be copied and pasted into Excel. The numbers are each on their own line.

Here's a sample:

Product A

Expired Status 1

Expired Status 2

Expired Status 3

Expired Status 3

etc. repeated for each product / status combination

What I'd like is a one line per product report with each status in its own column

Product Name Count for Status 1 Count for Status 2 . . .

Product A 1 10 3 5

Product B 10 . . .

etc.

Is there some way that I can get summaries or perform calculations so that these numbers are more table-like? I'd appreciate any direction you can provide.

Create an account or sign in to comment

Important Information

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

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.