0
I have a pivot table which is huge with raw data has more than 800,000 lines. I have customers in the row labels and month or year in the column labels.
Each month this pivot tablr grows adding on the previous month of sales data reporting, e.g. I just finished compiling and reporting February sales, so I have all of 2012, 2013 and now January and February of 2014.
From this pivot table, I need to pull out any account in the current month having sales where all other months have none. I'm struggling on how to achieve this in the pivot table. So I'm thinking I need to find a formula that yields a Y/N for new or not in a column of the raw data.
Can anyone help or advise how this can be accomplished? I'm more than willing to also send a sample of data so you can see how my pivot is laid out and how the raw data looks as well.