I notice a lack of a DataAccessPages help forum. So I will post in here and pray soeone can help me.
I am using a Pivottable in a DAP, and I have a very large query it is analysing, around 45,000 records. My problem is that the pivottable object is only returning 10,000 random records which is throwing off my stats.
I cant find the option in the properties or proprty box for hte object ot change this setting.
Anyone here able to help?
I am using a Pivottable in a DAP, and I have a very large query it is analysing, around 45,000 records. My problem is that the pivottable object is only returning 10,000 random records which is throwing off my stats.
I cant find the option in the properties or proprty box for hte object ot change this setting.
Anyone here able to help?