Pivot Table - Duplicated Data on Row Labels

T

Tarig

Hi,
I am using Excel 2007.
I have a Pivot Table that extracts data from an ERP, from which I am using
two tables, table (1) contains account code and transaction amount while
table (2) contains account code and account code description which is not
available in table (1).
When I choose both account code from table (1) and account description from
table (2) in Row Labels field together with transaction amount in ∑ Values
field I got a pivot table showing account code and ∑ transaction values in
one row and account code description and ∑ transaction values in the next
row!
Is there a way to remove this duplication and have account code and account
code description in one single row?
Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table – Duplicated Data on Row Labels 2
Dealing with a Pivot Table (when I don't want to) 0
Excel - Wich Function should I use? 1
Pivot Table - Row Label Combination 0
Append Crosstab Query to Existing Table 0
Pivot Table Question 1
Pivot Table - Hidden Data 0
Repeating a row other than the 1st row as the header row in a table from next page 1

Top