Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Excel export: can crosstabs automatically become pivot tables?
Migrateduser
<p>Hi everyone,</p><p> </p><p>I am looking for a more 'managable' solution to automatically create pivot tables when reports with crosstabs are exported.</p><p>What I am doing at the moment is this:
On page 1 of the report there is the crosstab, nicely formatted and human readable.
On page 2 there is just a plain table with the data that the crosstab on page is buid on. It is formatted in ISO formats so Excel knows how to handle the values. If this page is exported it's "just" a matter of a bit of selecting, clicking and draggin aroung to create the pivot table. 30 seconds max.</p><p> </p><p>But none the less I would like to spare myself the hassle of integrating said table and having to click around in Excel, I want the crosstab to be a pivot table automatically.
I was looking into maybe using a different emitter which might be able to do that, but that doesn't seem to solve my problem as I found no emitter being able to do that (at least no free one).
Are there other ways that are worth checking out?
Thanks in advance!</p>
Find more posts tagged with
Comments
There are no comments yet