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
 
R

Ronx

You will get better answers if you post this question in a forum or
newsgroup dealing with Excel - FrontPage is for web pages.
 
T

Tarig

Oooops, thanks
--
tarig


Ronx said:
You will get better answers if you post this question in a forum or
newsgroup dealing with Excel - FrontPage is for web pages.
Click to expand...
 

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 0
Dealing with a Pivot Table (when I don't want to) 0
Remove Identical words 0
VBA Pivot Table Error 1
Mail Merge Help 1
Creating a Chart on form from selected data in query. 0
Unable to display values in 2nd list box from 1st list box selection 2
Pivot Table - Row Label Combination 0

Top