pivot table 2013

Hi all, I’m using Excel 2013. I swear my VBA code used to work on pivot tables under Excel 2010, but it hasn’t worked for a few months now. We use a year/month code in our database. It’s not a ‘date format’. It’s actually treated as a text field. The month code for March 2014 would be...

Hi, I have a set of columns (Project, Employee, Week 1, Week 2 .. etc.) with values in them for about 3000 records. Since I didn't want any calculations to be done to the values in the Date columns, I added them to the Row labels instead (Tabular Form). Now the problem is that I need the total...

Hi Folks I'm using Excel 2013. I have 12 countries that are in a slicer. The pivot table contains Customer data i.e. name, invoice number, amount etc... Now what I have done is to add extra columns to the end of the data which is the Account Manager's feedback. When a country is selected from...

hi guys So im working on large data sets with about 2000 entries. i want to be able to 'decompose' the multiple entry fields so that they fall in the right places ( with 1 count for 1 unique name) an example my spreadsheet Name Location for holiday David...