Totals on Straight Table

[#1]

Good afternoon,

Hello

I have a straight table and I am creating totals for a particular column based upon breaks in another field.

I now have the following:

Account Number     Acct Desc       Balance           Total

1234                        Fred                1000                1200

1234                        Fred                  200                1200

1234                        Fred                                        1200

I am having an issue blanking out the total in the first 2 rows.

Thanks,

Mitch

[settu_periasamy]

As i already mentioned,

  In the Dimension limit Tab ->  Check the "Show Total" option  for your "Effective Date" Field.

Did you check the document?