working w/ the pivot table

Your question is still unclear to me and unable to understand what is your expectation is?

I understand that you have confidential info, but showing pics (and blurred out pics at that), just doesnt give us anything to really work with. Im not going to retype your data, and I doubt many other will either.

Try and put together some dummy workbook and upload that. I *think* I understand what you want, but cant be sure until I see some actual data - in a workbook

Hi

I guess you mean you want to see the results in the format you have on sheet 1 without typing in the values.
See the attached workbook.
I changed your PT report layout to Tabular form and got rid of Subtotals.
Then I inserted a GetPivotData function into cells C2 and D2 of Sheet1 and copied down.

the standard GetpivotData function returns the following if you type = into a cell and then point to the value on the PT. For example when picking up the value required in C2 of sheet1 you get

=GETPIVOTDATA("Sum of Net Qty Sold",'Pivot Table'!$A$3,"FNLN CAT","13003","FNLN CAT NAM","PREMIUM BRAKE PADS ")

I modified this to
=GETPIVOTDATA("Sum of Net Qty Sold",'Pivot Table'!$A$3,"FNLN CAT",A2)
We don't tnedd the second reference, as there is only one description to go with each Category, and, in any case it would not work for all rows as you Have Monroe Brake Drums on your report and it is MBD in the Pivot Table.
So the formula is modified to
=GETPIVOTDATA("Sum of Net Qty Sold",'Pivot Table'!$A$3,"FNLN CAT",A2)
where the cell A2 is used instead of the "130003"
This allows the formula to be copied down the remainder of column C.

Similarly for D2, the formula is
=GETPIVOTDATA("Sum of Net Sales Amount",'Pivot Table'!$A$3,"FNLN CAT",$A2)

Now, whenever you refresh your PT, your rpeort will get altered automatically.

(By the way, the values are all different to those that you were showing in your report).