Created pivot (Pivot1) from a table (Table1), but the pivot left out a record that appears on the table. Copied the table to a new worksheet, pasting it as values only, then converted it to a table (Table2) and created a pivot (Pivot2) from that. The original record was now in the new Pivtot2; however, two other records are now missing from Pivot2. How can I fix this? Thanks
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Pivot Table missing records
- Thread starter Alianza
- Start date
Excel Facts
Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.
Similar threads
- Question
- Replies
- 4
- Views
- 251
- Replies
- 0
- Views
- 69
- Question
- Replies
- 0
- Views
- 387
