Extract Data from Pivot table dynamically

[rajcobra]

Dear Friends,

I have created dynamic Pivot table thru Name Manager, and trying to extract category data for each individual company to a normal table thru below formula. But I am unable to do so.

=IF($R5 == (ISNUMBER(SEARCH("RAJ",$V$3)), $S5, "")

Kindly help. Have attached picture of the data required below.

 

[BSALV]

it 'll be better to repeat the company in the empty cells of your pivottable (setting of your PT)
But it's difficult to advice you a method with only a screenshot.

 

[rajcobra]

it 'll be better to repeat the company in the empty cells of your pivottable (setting of your PT)
But it's difficult to advice you a method with only a screenshot.

Dear,

Have attached better screen shot as I am unable to upload my sheet. I am basically trying to get Category & Total column (C6 to C32 & D6 to D32) data into F6 & G6 table based on company name respectively.

Kindly request your help.

 

[BSALV]

i suppose org1 = raj
if Raj is in E4, then with getpivotdata-formula and you point to the right cells, you can get everything.

Map1
	E	F
4	Raj
5	category	inventory value
6	chel	222
7	-	-
Blad1

Cell Formulas
Range	Formula
E6:E7	E6	=IF(ISNUMBER(F6),C6,"-")
F6:F7	F6	=+IFERROR(GETPIVOTDATA("inventory value",$B$4,"company",$E$4,"category",C6),"-")