Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Not quite clear... Probably you need expression or calculated dimension count(empid)
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