I am using the olapdatagrid and am using a date field as a
column axis. For the other axis I have an account hierarchy. For
the measure I am using a sum aggregator.
When aggregated the data contains 5 different dates. The
problem is that where an account contains values for only some of
the dates, the olapdatagrid displays NaN which looks as though
there is an error.
I would prefer it displayed 0 but a blank (as per the Excel
Pivot Control) would suffice.