This week I have presented a course, very short course, in Kuala Lumpur. It was not entirely an Excel course but one of the files I developed is a pivot table with no data. That’s right: no values at all.

What’s the point of a pivot table with no data? There are many points in this case, take a look:


What’s that then? Some words and phrases with a column saying No … number. Yes, that’s a count of the number of times, for example, customer satisfaction appears in a database when sorted in terms of one particular parameter … KPIs in this case.

A similar one says this,


More entries this time so it’s a bigger table! Again, it’s just a count of things … there are no values!

Thirdly, how about this?


Not only are we just counting things but we can slice the pivot table too: four slicers allowing us to interrogate the listing of 342 KPI measures in more and more refined ways. Look, I have sliced the summary pivot table four ways, as you can see below and that has le me to fine tune my view by finding just 1 entry out of the 342:


Download the file app_kpi_parmenter_trainer and see what I have done. I cannot claim the credit for the listing of the 342 KPIs, that honour and distinction goes to David Parmenter.


Duncan Williamson

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: