Pivot Table format !

T

Tufail

hello all,
i am using 2 PT and there in Row Labels date are in two style, i means one
can group wise and other are just showing each date entry wise, how can i
convert into group wise style insted each entry ?
 
S

smartin

Tufail said:
hello all,
i am using 2 PT and there in Row Labels date are in two style, i means one
can group wise and other are just showing each date entry wise, how can i
convert into group wise style insted each entry ?
Click to expand...

In a pivot table you can use date grouping features on a dimension (row
or column field) as long as the source data for that field contains
nothing but dates -- any blank cells or text will disable the date
grouping feature.

Note this means if you use full column references for your PT, date
grouping will probably not be an option.
 
Top