R
Rene
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?
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?