LinkBack URL
About LinkBacks
The data I want to include in my pivot table only starts around row 200 but I need row 1 as it contains my field buttons. How do I skip the rows?
The data I want to include in my pivot table only starts around row 200 but I need row 1 as it contains my field buttons. How do I skip the rows?
Not easily - a PT is really designed to work with contiguous data.
Either
a) repeat the headers prior to row 200
b) add a field (if nec.) @ source adjacent to your data to be used as a page field such that for rows 2:199 it is 0 and 200 onwards is 1 ... you can then exclude the rows 2:199 data from your analysis by selecting 1 in the Page Field.
Last edited by DonkeyOte; 11-05-2009 at 05:21 AM. Reason: typo
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks