Piviot table to create a grid view "cannot enter a null value as an item or field"

**Sordini** · 08-05-2014, 04:14 AM

Hi everyone

I can not for love nor money figure out what is going wrong here. Workbook attached with two worksheets. Any tips would be very much appreciated

Kind regards
Sordini

**oeldere** · 08-05-2014, 04:31 AM

Maybe like this?

**Sordini** · 08-05-2014, 11:24 AM

Thanks so much for the response. Draging and dropping is not the problem. I would like the countries repeated in one column. Not using lots of columns. I keep getting those error messages shown and have no idea how to proceed

Piviot table to create a grid view "cannot enter a null value as an item or field"

LinkBack

Thread Tools

Rate This Thread

Display

Piviot table to create a grid view "cannot enter a null value as an item or field"

Re: Piviot table to create a grid view "cannot enter a null value as an item or field"

Re: Piviot table to create a grid view "cannot enter a null value as an item or field"

Thread Information

Users Browsing this Thread

Similar Threads

Pivot Table - How to "add a data column" "of the same field" "across multiple sheets"

Create Macro that allows to enter "J" for "JOHN" etc

[SOLVED] Powerpoint Macro for Pressing "Enter" Key after Commas in First Slide in Normal View

Pivot Table: How to create a Calculate Field that uses a "Difference From" column

How do I go from "Chart View" to "Pivot Table Form" in a Pivot ta.

Bookmarks

Bookmarks

Posting Permissions