Pivot Table

[#1]

Hi,

I have one requirment to add custum calculated field on pivot table how to add that.suppose i have to display employee count.as custum filed in my table field empid is using for getting count of employee.

pls help on this.

Regards

Mahesh

[Anonymous]

Not quite clear...  Probably you need expression or calculated dimension count(empid)

[saumyashah90]

Yes you can get it by Calculated Dimesnion
count(empid) as CountOfEmployee

But it doesnt make any sense if you are using count() in dimension

You can also put this in Expression but same(doesnt make sense)

You can use text box differently.

One more thing you can do is when you put expression(You can give count as a title)

Better you analyse the data more nicely and come up woth better representation