I am not sure understood your question. However, when you add dimensions then it increases the granularity of the view. Previously you only had ID but now with category id on the rows, Tableau breaking your measures by these two dimensions.
Sorry for the confusion...
Let's use location 001 as our example...
In the first image we see that sales is $24455 and that SPG is 85.
When I drag categories in my Idea is to have the $24455 broken down by Categories... Which it does. and What I need is for those numbers to be divided by 85 for all the categories.
But when I do drag categories in it changes the value of SPG to an incorrect number.