S
Soe
thanx for reply, however, i still hav problems
1) it works only if it has only a few items.
If it has several items then i hv to hide such thousands of items. for
example, let say i want all data only for month of april, 1990, then a lot
of hiding has to be done.
is there any better idea?
2) i seems a bit dump here
not sure what u says as "field settings" mean "field" when i right click
on the field on pivot table.
Even it is so, however, i could not get "Automatic Subtotals" check box.
What I have seen is only when I choose "options", however, unchecking also
doesn't solve the problem.
can explain more in detail?
1) it works only if it has only a few items.
If it has several items then i hv to hide such thousands of items. for
example, let say i want all data only for month of april, 1990, then a lot
of hiding has to be done.
is there any better idea?
2) i seems a bit dump here
not sure what u says as "field settings" mean "field" when i right click
on the field on pivot table.
Even it is so, however, i could not get "Automatic Subtotals" check box.
What I have seen is only when I choose "options", however, unchecking also
doesn't solve the problem.
can explain more in detail?