Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to display current number of rows in a pivot table?

Hi,

As items are selected in listboxes, the number of rows change in my pivot table. What is the recommended way to display the current number of rows in the pivot table so the user doesn't have to manually count the rows as the pivot table changes?

Thanks,
Brian

2 Replies
Not applicable
Author

How I do it is add 1 as an expression with full accumulation.

Not applicable
Author

Thanks for your reply.

In my pivot table the options for accumlation are not available (greyed out).

Brian