Pivot table question

[lbzh]

I am creating a pivot table based off a stored function in Excel.

It returns Job codes instead of Job names to a data sheet in excel.

Another tab has a pivot table which references this sheet.

I want to convert the Job code into Job names (possibly using a formula) in the pivot table rather than in the data sheet. Is there a way to do this?

I know how to do calculated fields on data, but this is not data it is a Page field on the pivot table. I also try to insert a function, and it say it is not legal to use a function on the page field.

So basically I am trying to create an IF function or formula to say if the Job Code is 1 then Specialist, if the Job Code is 2 then Sr Specialist etc.

 

[xlbo]

In short - no - you are far better off doing this on the data sheet

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[Gavona]

Sorry if this is too late to help you.

If the job code is in cell B2 you could always have a lookup or whatever function in cell C2, referencing B2.

Now, I haven't found a way to format B2 in a 'normal' way to have a white font (ie invisible). Refreshing the table or changing the page field selection loses the format. My workaround would be to set a conditional format on cell B2 With the condition If Cell value does not equal "@@#" then font colour = white. (@@# is just any value that will never exist in the page field)


Gavin