How to get PIVOT table Vales as count instead of Sum

faheemsd — Thu, 23 Mar 2023 15:02:00 GMT

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

RE: How to get PIVOT table Vales as count instead of Sum

harish.mogulluri — Wed, 10 May 2023 17:37:00 GMT

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_gIVhhSzAB1FEQh-EAAYASAAEgIiA_D_BwE&_gl=1*17qnb3u*_ga*ODQ2MDg5OTU5LjE2NTcwNzM0NzI.*_ga_MFBQ2KFZ1L*MTY4MzczMzcyNC4yMjEuMS4xNjgzNzQwMTEwLjU2LjAuMA..

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

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

topic How to get PIVOT table Vales as count instead of Sum in Product Forum

How to get PIVOT table Vales as count instead of Sum

RE: How to get PIVOT table Vales as count instead of Sum