I have a large data set - 1,600,000 rows.
I am using powerpivot so I can use all the data set.
The pivot table itself however is still limited by the 1 Million lines.
Most of the time this is not an issue.
However I have one report where I want to display in the pivot itself more than the limit of 1 million lines.
Is there any option?
In my pivot display I have a customer name and a member status update - this goes beyond the limits.
I actually only need to see customer with the first activity ... this would reduce it the total list... but i don't seem to be able to display only the first date.
Thanks all...
Customer[TABLE="width: 582"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD="align: left"][/TD]
[TD="align: left"]Member Status Update Date[/TD]
[/TR]
[TR]
[TD="align: left"](blank)[/TD]
[TD="align: right"]27/11/2008[/TD]
[/TR]
[TR]
[TD="align: left"](blank)[/TD]
[TD="align: right"]08/06/2009[/TD]
[/TR]
[TR]
[TD="align: left"](blank)[/TD]
[TD="align: right"]29/09/2009[/TD]
[/TR]
[TR]
[TD="align: left"](blank)[/TD]
[TD="align: right"]01/08/2010[/TD]
[/TR]
[TR]
[TD="align: left"](blank)[/TD]
[TD="align: right"]01/09/2010[/TD]
[/TR]
[TR]
[TD="align: left"](blank)[/TD]
[TD="align: right"]01/11/2010[/TD]
[/TR]
[TR]
[TD="align: left"](blank)[/TD]
[TD="align: right"]02/11/2010[/TD]
[/TR]
</tbody>[/TABLE]
I am using powerpivot so I can use all the data set.
The pivot table itself however is still limited by the 1 Million lines.
Most of the time this is not an issue.
However I have one report where I want to display in the pivot itself more than the limit of 1 million lines.
Is there any option?
In my pivot display I have a customer name and a member status update - this goes beyond the limits.
I actually only need to see customer with the first activity ... this would reduce it the total list... but i don't seem to be able to display only the first date.
Thanks all...
Customer[TABLE="width: 582"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD="align: left"][/TD]
[TD="align: left"]Member Status Update Date[/TD]
[/TR]
[TR]
[TD="align: left"](blank)[/TD]
[TD="align: right"]27/11/2008[/TD]
[/TR]
[TR]
[TD="align: left"](blank)[/TD]
[TD="align: right"]08/06/2009[/TD]
[/TR]
[TR]
[TD="align: left"](blank)[/TD]
[TD="align: right"]29/09/2009[/TD]
[/TR]
[TR]
[TD="align: left"](blank)[/TD]
[TD="align: right"]01/08/2010[/TD]
[/TR]
[TR]
[TD="align: left"](blank)[/TD]
[TD="align: right"]01/09/2010[/TD]
[/TR]
[TR]
[TD="align: left"](blank)[/TD]
[TD="align: right"]01/11/2010[/TD]
[/TR]
[TR]
[TD="align: left"](blank)[/TD]
[TD="align: right"]02/11/2010[/TD]
[/TR]
</tbody>[/TABLE]