New Product Preview Part 2 – Pivot Tables in FileMaker Pro

We’ve just uploaded a second short (~ 4 minute) video showing the new features and look of our newest product in development CC Pivot. It is designed to make creating pivot tables in FileMaker quick and easy. Next week I’ll show how simple integration is, but for now I wanted to show a more proper pivot table display, enjoy!

 

Let us know what you think, or any suggestions you have, in the comments.

 

CC Pivot Sneak Preview from Cleveland Consulting, Inc..

**Update** We have released CC Pivot! You can find it here!

Court Bowman

Author Court Bowman

Court Bowman has been working with in the IT field his whole life, working as a network engineer, database developer in Oracle and Progress and as a IT director for several firms. He has been working with FileMaker Pro since version 2 and has been a reoccurring speaker at the FileMaker developer conference. Apart from his expertise in FileMaker Pro he has experience in system architecture and design, data modeling and database architecture. He also has years of experience as a process and workflow consultant and has helped with the design and deployment of hundreds of systems in FileMaker and on the web.

More posts by Court Bowman

Join the discussion 2 Comments

  • Matt says:

    Hi Court, Looks great! Can’t wait to see and play with it.
    One more suggestion of what I would need to do with it. I would need to display child data across in columns, like you did with offices. So, I would like to be able to pick fields from a related table too. Is this possible? I would want to list records from a parent table in rows with a few specific fields; i.e., Product ID, Product Name, Price. Then in additional “pivoted” columns list the STORE NAMES (from a child table field, Store Name) and filter by UNITS SOLD. This would then give me a list of products and total units sold in each store.
    I’d be happy to send some examples if you’d like.
    Great Job!

    • Court Bowman says:

      Matt,

      Thanks for the feedback. The quandry on that issue is two fold. While not technically complicated, the interface for choosing a field from another table is a bit trickier. We currently do not require any complex integration, so to show related tables, we’d have to ask you to tell us what tables are related and how. Then there is the speed issue, it would be possible with related tables to ask for data so complex that you’d crash FileMaker, or at least bring it to such a crawl that you wouldn’t return from the process for hours.

      The second issues is more of an awareness issue, but i don’t want too many folks stuck with a request so complex it’s unfulfillable. but the first one is one we’re struggling with.

      Any thoughts or insight are more than welcome. We’ll likely open an alpha testing in the next week or so, if you are game to take a peek and give us some feedback I’d be glad to include you.

Leave a Reply

All rights reserved Cleveland Consulting.