M
Michal Chmielus
I am using OWC 11 and select some rows.
If I try using NumberFormat property for DataAxis.Totals fields and
set the format, i.e.: [Black]0.00;[Red]-0.00;[Black]0; just sets only
the blank field in Grand Total. Even if each aggregation has correct
value (not #VALUE) as grand total Pivottable component gives me
#VALUE.
Any ideas?
Michal
If I try using NumberFormat property for DataAxis.Totals fields and
set the format, i.e.: [Black]0.00;[Red]-0.00;[Black]0; just sets only
the blank field in Grand Total. Even if each aggregation has correct
value (not #VALUE) as grand total Pivottable component gives me
#VALUE.
Any ideas?
Michal