D
Douglas Booton
I have two pivot tables based on the same list. I want to combine the
results.
For example:
I have four columns of data in my list, Col A, Col, B, Col, C, Col D.
Col A, Col B, and Col C are all unique rows and I want to show them.
The first pivot accomplishes this easily.
However Col D has a value that is the same for all unique combinations
of Col A, Col B, and Col C. When I add the last column Col D it ends
up repeating many times for each unique combo of the above three
columns, and I don't want that. So I made a second pivot and just
filtered out for one unique occurenece of the three columns, and now
want to append it to the first pivot.
I just want it to act as a "Summary" type field that sits as the last
column in the pivot table.
Does this make sense? Thanks
results.
For example:
I have four columns of data in my list, Col A, Col, B, Col, C, Col D.
Col A, Col B, and Col C are all unique rows and I want to show them.
The first pivot accomplishes this easily.
However Col D has a value that is the same for all unique combinations
of Col A, Col B, and Col C. When I add the last column Col D it ends
up repeating many times for each unique combo of the above three
columns, and I don't want that. So I made a second pivot and just
filtered out for one unique occurenece of the three columns, and now
want to append it to the first pivot.
I just want it to act as a "Summary" type field that sits as the last
column in the pivot table.
Does this make sense? Thanks