Block user before adding new pivot table field

[jaryszek]

Hi Guys,

it is possible to block user before adding specific field (TotalServers in my case) into pivot table?

Best,
Jacek

[romperstomper]

What exactly do you mean by "block user"?

[jaryszek]

Sorry for my english Rory,

I mean "Prevent" user.
So i have page field (filter part) in pivot table and i do not want user to touch it. (to add as colum or row or just turn off - untick field)

Jacek

[romperstomper]

You can do it in code:

Please Login or Register  to view this content.

[romperstomper]

You could also remove it from the pivot table and use a slicer instead.

[jaryszek]

thank you very much!

Can i prevent user for changing slicer?

I think i will hide this field and not allow user to change it with your code.

Jacek