Results 1 to 2 of 2
Thread: Problem with Pivot Table.
2014-03-01, 01:36 #1
- Join Date
- Mar 2014
- Thanked 0 Times in 0 Posts
Problem with Pivot Table.
Any body please help me in attached file i have issue in pivot table i want to marge musa and musa(acting) in 1 singal bar or in 1 singal column please guied me whats the formula to marge both fields in 1 column untitled.JPG
2014-03-01, 08:02 #2
- Join Date
- Jul 2002
- Pittsburgh, Pennsylvania, USA
- Thanked 342 Times in 335 Posts
There is no attached file, just a picture.
Since this seems to be a pivot chart, I would suggest you go to the source data and add a new column of "merged Names" (or whatever you want to call it). In this you can put the name you want to group in. You can do this manually (since there does not appear to be many names) by auto-filtering on the various Supv names and then filling the mergedName column with the name you want to use. If there are a lot of names, what you could do is create a list of all the names and what the merge name should be (on a separate sheet perhaps) and then use VLookup to get the merged name.
Once you have the merged name column, you can use this in the pivot chart.
Post back if you need more details or if I misunderstood your request