Product was successfully added to your cart.

New Product Preview – Pivot Tables in FileMaker Pro

We’ve just uploaded a short (~ 5 minute) video showing some of the features of a new product we have in development, CC Pivot. A product designed to make the display of data in a pivot table like format easy and quick in FileMaker Pro.

 

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

CC Pivot Sneak Preview from Cleveland Consulting, Inc..

Update: We’ve added a second video showing a little more about this upcoming product.

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

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 8 Comments

  • Matt says:

    Interesting. Nice work, but isn’t this something we can create in FileMaker directly? I think it’s great for a custom report builder and I see definite uses for the user having the ability to create their own reports using this.

    However, a true Pivot table would allow me to take something like the field Category and “explode” it’s data across the table instead of down. So, now it would show Equipment, Other Services, Personnel Compensation, etc. going across as headers. Then the Amount would display directly beneath, summarized by month, day, year or whatever. You would then need one other component in your selector, the break field or summarizer; i.e., by month, day, department or whatever.

    Now this would be a huge asset to the FileMaker community. I have a need for it right now fro one of my clients. We’ve always been abel to display data going down, but going across is a huge headache, as you know (separate fields, etc.).

    If you’d like to discuss further, let me know and I’d love to see this truly developed as a Pivot table creator!

    • Court Bowman says:

      Matt,

      Thanks, great comments. Two things. First, yes while you can do something like this in FileMaker, but what is hard is to do it without any schema or structure. In this case, we have no fields, layouts or relationships dedicated to any particular view. It’s all dynamic.

      Second, in regards to showing data across both or either axis. That is indeed better, but this was just a sneak preview, I didn’t show everything. 😉

      • Matt says:

        That’s fantastic and I’d love to get this into the hands of my users for their own report building without having to change schema! I assume I can keep everything “behind the scenes” locked down and let them report away…

        Well then, I’ll definitely be waiting to SEE everything!

        Will there be an export to Excel option too? I’d like to see the printing as well.

        Good luck finishing it up!

  • I agree with Matt. The title is promising but what you show is not a pivot table. If you plan to really implement a pivot table then this will be an amazing product. And it definitely is something that can be done in FileMaker, maybe with a bit of SQL or repeating fields use…

    I am relly looking forward to see what the final product will look like. Good luck!

  • Colleen says:

    Looks very nice Court! I second Matt’s comments, especially an ‘Export to Excel’ feature 🙂

  • Denis says:

    This looks great especially if it is light on any requirements of adding fields to existing solutions. Does this also require a plugin to be installed?

    • Court Bowman says:

      Thanks for the comment. We do have one custom plugin made with the great tool from 360Works, ScriptMaster Advanced. It will be included with the product. It does not however require any changes made to your system. No new fields, layouts or scripts.

Leave a Reply

All rights reserved Cleveland Consulting.

Call Now Button