count Get Pivot

Pivot Table Summary Functions: Max and Min

Saturday 17 July 2010 @ 12:52 am

In recent blog posts, we’ve looked at the pivot table Count function and the Average function. Now we’ll look at two more functions, that are closely related –

Continue Reading »
Pivot Table Summary Functions: Max and Min

Comments (0) | Posted in pivot

how to count columns i pivot table? in Excel Programming

Sunday 24 January 2010 @ 4:08 am

Hi My pivot is dynamic, created with VB, and number of columns will vary. I need this count in a variable for use in further processing. Any a.

Continue Reading »
h ow to count columns i pivot table? in Excel Programming

Comments (0) | Posted in pivot, pivot table

Calculated Fields in Pivot Tables using Existing aggregates in …

Thursday 14 January 2010 @ 8:31 am

In an Excel [2003] pivot table , I need to calculate a new field based on the COUNT of one field and the SUM of another (and other similar calculations.

Continue Reading »
Calculated Fields in Pivot Tables using Existing aggregates in …

Comments (0) | Posted in pivot, pivot table