How to create a pivot table from collection data or excel's data
Anonymous
Not applicable
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
17-05-18 05:39 PM
Hi,
I've a requirement of creating a pivot table from a data stored into collection or excel.
Does anybody knows it how to achieve this?
3 REPLIES 3
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
17-05-18 09:12 PM
The simplest option is to manually create a template Excel file with 2 sheets, one containing the pivot and one for the data. Create the pivot manually with some test data and save the template. Then have BP open the template, overwrite in the data and save a copy of the file.
The Excel VBO does not have any 'create pivot' actions, you would need to create them. And given that there are many settings to a pivot table, this would not be an easy job.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
17-07-18 07:51 PM
So for any process related to pivot, is it easier to just navigate on the Excel UI?
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
18-07-18 08:40 AM
Probably not, although I have never tried. I think using a pre-made template is the easiest but that approach may not suit every project.
