S
Seth
Trying to create a pivot table with a field defined as a
percent with two decimal places. Looks good in table and
query; however, when creating the pivotable the field
format is lost and all valid percentages result in zeros
(except for the 100% = 1). After redefining the field as
a percentage in the pivot table, the data remains as
zeros. Can anyone help me retain the data as a percentage
from the table and query?
Thanks,
Seth
percent with two decimal places. Looks good in table and
query; however, when creating the pivotable the field
format is lost and all valid percentages result in zeros
(except for the 100% = 1). After redefining the field as
a percentage in the pivot table, the data remains as
zeros. Can anyone help me retain the data as a percentage
from the table and query?
Thanks,
Seth