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
<colgroup><col><col></colgroup><tbody>
</tbody>
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
Member Status Update Date | |
(blank) | 27/11/2008 |
(blank) | 08/06/2009 |
(blank) | 29/09/2009 |
(blank) | 01/08/2010 |
(blank) | 01/09/2010 |
(blank) | 01/11/2010 |
(blank) | 02/11/2010 |
<colgroup><col><col></colgroup><tbody>
</tbody>