Get pivot table to show row label if no data is there

bump
10 chars

Hi,

I have a vague understanding with too much murkiness still. So it is difficult to advise. And certainly nothing too specific.

I have an idea that may be suitable but I don't know. It involves creating another field so that the result of the filtering is achieved via the new calculated field. So you currently have the billable hours and actual hours and I think the result can be achieved with another billable hours. This second billable hours being different from the first. A little like this, I hope it gives a flavour of the idea,

So the new field is created in SQL in between the source data and the pivot table. I have described such approaches in many other threads & will look for an example after posting this reply.

That is as good an answer I can give for my current understanding. Regards, Fazza

A brief selection from the more recent threads. They might give you some ideas?

http://www.mrexcel.com/forum/showthread.php?t=315768

http://www.mrexcel.com/forum/showthread.php?t=345697

http://www.mrexcel.com/forum/showthread.php?t=384826

http://www.mrexcel.com/forum/showthread.php?t=386359

http://www.mrexcel.com/forum/showthread.php?t=403980

http://www.mrexcel.com/forum/showthread.php?t=406058

HTH, F