ssrs totals problem

• suresh.muppidi

  Right there with Babe

  Points: 761

  More actions

  June 8, 2010 at 12:23 am

  #225366

  Hi,

  I have Hierarchical data ie., AccountNumber and Child Account Numbers like as shown below....

  Expences

  10001 - Parent Account

  10001-001 - Child Account

  10001-002 - Child Account

  10001-003 - Child Account

  10002 - Parent Account

  10002-001 - Child Account

  10002-002 - Child Account

  10002-003 - Child Account

  Here Expenses is the Type Code and followed by Accounts hierarchy. The data was getting from a cube.

  Now my problem is

  Amount

  Expenses 8200 (Expenses Total)

  10001 1100

  10001-001 1000

  10001-002 250

  10001-003 -150

  10002 3000

  10002-001 2000

  10002-002 500

  10002-003 500

  As shown above total expenses was showing 8200, but correct total is 4200,

  that is the totals adding once again.......

  can anybody tell me how to fix this issue......

  Thanks in advance,

  Suresh.

• suresh.muppidi

  Right there with Babe

  Points: 761

  More actions

  June 8, 2010 at 1:00 am

  #1177328

  sorry correct total is 4100

  3000 + 1100 = 4100.