adityagoswami
New member
- Joined
- Sep 17, 2013
- Messages
- 2
- Reaction score
- 0
- Points
- 0
Hi, am new to excel. I have a data sheet which has data as per exp heads, locations, (Quarter, Plan and Year- Q1 OP13) wise. I had built a pivot as per Exp heads and facilities and Plan wise, i need to extract only a few of the expense heads numbers as per facility on a different sheet. I tried using GETPIVOTDATA() FUNCTION, bt i guess am using a wrong syntax. Am attaching a example which does nt have all the expense and locations. I would need the data only fr a few expense heads from the pivot using getpivot function. Can someone help.