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