Actually I want to filter the one column based on the role of admin for e.g, all projects should be visible if user has admin role or otherwise only some projects should visible. I can write it as query but how it can implemented in pivot excel Is no idea.. Can anyone help with this. Please
