K
kejku
How can I custom format a pivot table? I am not looking to click on a cell
in the table and format the cell I am looking to modify one of the auto
formats or create my own format to be used with the Pivot Table.
In the layout screen, when setting up the Pivot Table you can drag fields to
the row, colum, data or page to the areas of the diagram. I want to be able
to modify the formating of the different levels of the row area. What I mean
is that if you drag over two fields to this area when you post the data and
use an auto format it has the formating already selected based on the level
of the "outline" that you are at.
I want to be able to create a format and then save it as my personal format
for the pivot tables that I use. Is this possible?
in the table and format the cell I am looking to modify one of the auto
formats or create my own format to be used with the Pivot Table.
In the layout screen, when setting up the Pivot Table you can drag fields to
the row, colum, data or page to the areas of the diagram. I want to be able
to modify the formating of the different levels of the row area. What I mean
is that if you drag over two fields to this area when you post the data and
use an auto format it has the formating already selected based on the level
of the "outline" that you are at.
I want to be able to create a format and then save it as my personal format
for the pivot tables that I use. Is this possible?