#1
|
|||
|
|||
Pivot Table Filter Issue
Hi I have source data that includes dates, source, revenue, and campaign
I have a pivot table that shows Dates in columns and the rows are filled with the source and revenue amount. Additionally I have a filter by campaign. The Campaign data includes mostly numerical campaign numbers, but there are some that are alphanumeric. When I have the data source on one tab and the pivot table on another tab within the same spreadsheet it works fine. My issue: When the data source and pivot table are on separate spreadsheets the Alphanumeric campaigns don't get pulled into the filter, the data associated with those campaigns comes through but the campaign is listed as "blank". |
#2
|
|||
|
|||
can you post an example? its much eaiser to understand the issues if we can see them
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
[VBA] Filter Pivot Table by dates | Levi92 | Excel Programming | 0 | 11-14-2018 07:43 PM |
Pivot table dates issue | salse | Excel | 1 | 06-08-2016 12:23 PM |
Create PIVOT chart using few rows in pivot table | Santhosh_84 | Excel | 1 | 08-31-2015 06:22 AM |
Pivot Table issue | ominae | Excel | 1 | 07-18-2014 01:40 AM |
Pivot Table Issue | Grovesy | Excel | 0 | 10-28-2012 09:08 PM |