After you have already created a pivot table is there any chance you can alter certain cells? As it says, "Cannot change this part of a pivottable report." Thank you for any help.
Basically I've got a whole load of raw data and I've been able to create a pivot table so it just shows the relevant info I want. The problem is whenever creating the pivot table the variance columns I have turn to the "Count of".
Now I've tried changing it to the other options but isn't...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.