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:

pt_no_values_1

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,

pt_no_values_2

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?

pt_no_values_3

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:

pt_no_values_4

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:

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

%d bloggers like this: