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.