Re: Pivot Table Filtering by Subtotal
Its a progress database, sitting on our main application server which is running Linux. I can't get an ODBC link into the database because of the way in which it has been designed.
What I do to create the CSV files is run a large report for the month [or half the month if theres too much data] and save it as a text file. Then I run an Excel macro that extracts the information I want and puts it into several columns. I then save the completed month as a CSV File.
After that I just open up the CSV File in wordpad and Copy / Paste the information into the CSV "masterfile", and then use the Microsoft Text driver to bring the data into my Pivot table.