How to get PIVOT table Vales as count instead of Sum

[faheemsd]

Hi All,

I'm trying to add the Pivot table Value columns and I'm getting the result as Sum of the Column Name but I want the Count of the Column name Instead of Sum.

Could you please help me on this how can I achieve this and any code available to get this done?

Below is the screenshot to understand the scenario

------------------------------
SYED FAHEEM
RPA Developer
DAR-ME
Asia/Kolkata
------------------------------

[harish.mogulluri]

HI Syed Faheem -
Create a template for pivot table as well as expected columns 

I did some thing like this in the past 
Created a template
1) Worksheet1 - Create column name from the expected data 
2) Workshee2 - Create pivot table based on the worksheet1 columns and enforce the count in the template

Get the data from BP coll  and paste in to  the Worksheet1( Make sure all the columns in the collection and excel  column names should match and order should be the same)  and navigate to the worksheet2 and select refresh button which will reflect the data in to the pivot table based on the data  pasted in worksheet1.

Other option would be try  "Function for MS Excel VBO - Extended - 2.3.3"

https://digitalexchange.blueprism.com/dx/entry/9648/solution/ms-excel-vbo---extended?_ga=2.51120618.2143198501.1683549936-846089959.1657073472&_gac=1.251250226.1682567749.EAIaIQobChMIjNuroZXJ_gIVhhSzA...

------------------------------
-----------------------
If I answered your query. Please mark it as the "Best Answer"

Harish M
Lead developer
America/New_York TX
------------------------------