function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion

Salesforce, Conga and Pivot tables

Has anyone managed to produce pivot tables based on reports generated via Conga Composer on Excel? 
Maureen LacknerMaureen Lackner
This post has been up for a while, but if you're still working on this, the answer is yes! First, create a table in excel and put your conga merge fields in the columns. Next create a pivot table that uses your excel table as a data source. For some reason, I can only make this work with PCs, but when you merge the template, the table will populate and the the pivot table will update with your salesforce data. It will take some trial and error to get it to sort/filter the way you want it to, but I have been able to create pivot tables and pivot charts using this strategy. Good luck! 
Eric KintzerEric Kintzer
Thanks Maureen; an alternative to your approach is to use Excel ranges (that is, you don't need to define a table to start with). Place your Conga field headers plus merge fields in, say, row 1 and 2 of some worksheet 'Details'. Then insert your pivot table on a separate sheet and reference range: Details!$A$1:$G$2 (assumes you are using columns A-G).  You also won;t want to use any of Conga's built-in subtotals on Details as this will mess up the pivot.  The range works because as Conga populates the template, Excel will auto-expand your range to match the number of instantiated rows + 1 (for the header)