Ravi Kiran
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks , this is a great help to me
is that what u were looking for?
PivotTable.xlsx