Pivot table RangeSum() with a strange row at the bottom

[Anonymous]

Hi, all,

Today I see a strange behavior of pivot table when using RangeSum() (also RowNo()) to calculate the data as in the attached snapshot.

When I add the third expression "=sum(Spend)", there is a line suddenly appears at the bottom of the table "Revenue 1", and before that, the table is as "Revenue 2". I do not need this row, but do not know how to get rid of it. Dose any one have any clue?

Thanks very much

[sushil353 · Accepted solution]

In Dimension > suppress null values.

HTH

Sushil

[jonathandienst]

You most likely have a record that is missing the date, possibly caused by a faulty join in your load script or a problem with your source data. If you are satisfied that this does not represent real data, you can suppress nulls as the previous poster suggested.

A better solution is to trace where these records are coming from and work to eliminate them from your model, or to correct them with a valid date.

[Anonymous]

Hi, Sushil,

Thanks very much, it works!!!

[Anonymous]

Hi, Jonathan,

Yes, I think you are correct, I think the expression "sum(Spend)" calculated some other data has no date.

Thanks very much for the suggestion