LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Johan
 
Posts: n/a
Default Merged cells and Pivot table

I have the following tabel
A B C
Region Customer Product
1 ASIA Custo Apple

Since one customer can have more products and a region more customers I used
in the table mergd cells to keep the overview. However when I am using this
data in my pivot table only the first complete row is stated in the pivit
table. Any ideas how to solve this?

regards

Johan
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Change Data In Pivot Table John Calder New Users to Excel 1 July 7th 05 10:41 PM
formulas referencing pivot table cells JW_WA Excel Worksheet Functions 1 February 8th 05 12:52 AM
Counting blank cells in Pivot Table Andy Joyce Excel Worksheet Functions 1 December 21st 04 10:05 PM
Password protect cells PivotTable & allow the Pivot Table to refre KJThams Excel Worksheet Functions 2 November 30th 04 04:13 AM
Pivot table, how do you exclude counting cells with formulas as a Greg Bobak Excel Worksheet Functions 4 November 4th 04 12:05 AM


All times are GMT +1. The time now is 09:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"