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

How to export table from outlook into ms access table? 0
How to Populate Data from a table to another 0
VBA Pivot Table Error 1
Pivot Table Question 1
Calculated Field in Pivot Table 1
How to setup database to make transactions (transfers) between two bank accounts 0
VBA - retrieve data on last create named range from previous inserted named range 0
Access #Error & Excel Pivot 0

Top