I need the Column C numbers at cell level to be shown in the Column E,H,K.And I need the absolute for now so that i can use them for further calculations.
If you can See the Grand Total Row doesn't give me correct addition when i see it for Manufacturer-A as Manufacturer-A doesn't have Product-7 and I need the Grand Total to be fixed for addition of all manufacturers(i.e Column C Grand Total)
When you write "I need the Column C numbers at cell level to be shown in the Column E,H,K.And I need the absolute for now so that i can use them for further calculations." I strongly suspect that you are using the kind of linear thinking that we use in tools like MS Excel where we start out with some cells of data, write some formulas that populate additional cells, then do some more formulas, and so on.
Tableau's model is different. Even though there is an underlying order of operations the parts are computed "all at once" so when we're deriving a result we may need to take drastically different routes in the software depending on what we want do next. The reason that I bring this contrast of models up is based on my experience helping users where they present challenges one piece at a time and it turns out to take a lot longer to get to a solution because we head down paths that ultimately don't get to the end goal.
Therefore my suggestion is to mock up some sample data, create a Tableau packaged workbook with your work so far, and create a mock up of your desired end goal. Then folks like Don and I will be in a much more informed position to help you out.
I managed to achieve it.