Hi Zahid,
Upgrade to Excel 2007, this wil provide you to analyze 1 million rows, and
16000 columns.
Else user SQL Server 2008 Analysis server.
Thanks
On Sun, Jun 20, 2010 at 12:28 PM, Chaudhry Zahid Ali <
chaudhry.zahid@gmail.com> wrote:
> Dear All,
>
> I have to apply pivot on a data that
Dear All,
I have to apply pivot on a data that reaches approx 1.5m rows and is spread
on 15 columns. If I divide the data in two parts of 0.8m rows each, I can
not do a complete analysis. Any suggestions??
Regards,
ZAC
--
> Dear all group Members,
>
> I am also a member of your very good group.
> I am very pleased to be in this group becasue i have learned a lot of excel
> from here.
> i would like to mention that in these days there is no mail i had received
> that contains attachment file from where i can understa
Dear all group Members,
I am also a member of your very good group.
I am very pleased to be in this group becasue i have learned a lot of excel
from here.
i would like to mention that in these days there is no mail i had received
that contains attachment file from where i can understand the proble
Hello Group,
*Overview:*
I have a issue to discuss. I have got an excel sheet which contains over
150,000 trial balance account subheads made up of data from different
branches (All Branches). So there are multiple account heads that are
repeating. I have constructed a Pivot table out of the data
