How Do I Take Pivot Tables to the Next Level?
 

Where can I get intermediate and advanced tips and instruction on the
possible variations of field arrangements in all 4 areas of a pivot table
report and what they'll yield? I recently used the same field in both the Row
Fields and in Data Items areas for the first time, in order to get a count of
each unique item, and it saved everyone a lot of time and they loved it. I
want to convert more lay people to the wonderful world of Pivot Tables.
Also, what types of files can I acctualy import into Excel for analysis via
PT reports? Any tips on importing external data like that?
--
Rene - Do appreciate your help

How Do I Take Pivot Tables to the Next Level?
 

try Debra's tips at

http://www.contextures.com/tiptech.h...9xHCrHJSkIWWoZ

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Rene" escreveu:

Where can I get intermediate and advanced tips and instruction on the
possible variations of field arrangements in all 4 areas of a pivot table
report and what they'll yield? I recently used the same field in both the Row
Fields and in Data Items areas for the first time, in order to get a count of
each unique item, and it saved everyone a lot of time and they loved it. I
want to convert more lay people to the wonderful world of Pivot Tables.
Also, what types of files can I acctualy import into Excel for analysis via
PT reports? Any tips on importing external data like that?
--
Rene - Do appreciate your help

How Do I Take Pivot Tables to the Next Level?
 

Obrigado a voce pela ajuda. Interessante que a 1a coisa que eu pensei qdo vi
seu nome eh que poderia ser um brasileiro. Valeu. Regards from New York.
--
Rene - Do appreciate your help


"Marcelo" wrote:

try Debra's tips at

http://www.contextures.com/tiptech.h...9xHCrHJSkIWWoZ

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Rene" escreveu:

Where can I get intermediate and advanced tips and instruction on the
possible variations of field arrangements in all 4 areas of a pivot table
report and what they'll yield? I recently used the same field in both the Row
Fields and in Data Items areas for the first time, in order to get a count of
each unique item, and it saved everyone a lot of time and they loved it. I
want to convert more lay people to the wonderful world of Pivot Tables.
Also, what types of files can I acctualy import into Excel for analysis via
PT reports? Any tips on importing external data like that?
--
Rene - Do appreciate your help

How Do I Take Pivot Tables to the Next Level?
 

Obrigado, pela resposta.


--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Rene" escreveu:

Obrigado a voce pela ajuda. Interessante que a 1a coisa que eu pensei qdo vi
seu nome eh que poderia ser um brasileiro. Valeu. Regards from New York.
--
Rene - Do appreciate your help


"Marcelo" wrote:

try Debra's tips at

http://www.contextures.com/tiptech.h...9xHCrHJSkIWWoZ

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Rene" escreveu:

Where can I get intermediate and advanced tips and instruction on the
possible variations of field arrangements in all 4 areas of a pivot table
report and what they'll yield? I recently used the same field in both the Row
Fields and in Data Items areas for the first time, in order to get a count of
each unique item, and it saved everyone a lot of time and they loved it. I
want to convert more lay people to the wonderful world of Pivot Tables.
Also, what types of files can I acctualy import into Excel for analysis via
PT reports? Any tips on importing external data like that?
--
Rene - Do appreciate your help