Help Needed in Creating a Pivot Table in MS-Excel

HI Experts,

I am trying to create a pivot table with the data  in the sheet 1 (of attached file PivotTable.xlsx )
I have created a pivot table with this data (sheet 4)

I am not getting table as my expectations

My expectation is as below

1. I need two columns to be displayed( 1. Row Labels 2. Product Cost in USD)
2. I need a tree for each row in the column#1
3. I need the standard cost of each item to be displayed on the column #2( for corresponding Item)
4. if i expand the tree in each row in column#1 it should display two nodes ( summer cost and winter cost)
5. I should not get the Item cost displayed multiple times on the column#2 (please see the sheet 4 for reference)


Please help me in creating such pivot table


Regards
Ravik
PivotTable.xlsx
Ravi KiranAsked:
Who is Participating?
 
Rob HensonFinance AnalystCommented:
Almost there with some rearranging of the data.

See attached.
PivotTable.xlsx
0
 
ProfessorJimJamCommented:
please see attached.

is that what u were looking for?
PivotTable.xlsx
0
 
Ravi KiranAuthor Commented:
Thanks , this is a great help to me
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.