Hi there,
Inherited some reports from another part of the business that heavily relies upon pivot tables. Unfortunately, I've NEVER had any experience with pivot tables and I'm stuck. The handover was brief and the previous owners are no more so I can't ask questions. Hopefully you can help.
I'm a DBA / Cognos developer so understand the back end of this better than the what the spreadsheet is doing! I have a pivot table that obtains it's data from an MS Query query that connects to a SQL database. One of the fields it returns is called dateapp.
In the pivot table fields, there is a filter called dateapp2 and dateapp is not used in the field list. The underlying table, there is only data in it > 01/01/2010 however, in the filter there is an entry reading "2005" and in addition dates from 01/01/2006 to 31/12/2009. This is proving a pain when trying to pull of YTD figures as I have select each date for 2010 seperately.
So first question, what is dateapp2? A custom field? How do I find out what it is doing? i.e. is it manipulating the dateapp field at all?
And secondly, where are the custom values coming from?
I appreciate that an attachment would be extremely useful but unfortunately due to the nature of the business I work in I am unable to upload anything from my PC to the internet.
If you need any further info to help you help me, please let me know
Thanks in advance.
Bookmarks