How to put Subtotals in Hierarchical Olap Matrix Report

• suresh.muppidi

  Right there with Babe

  Points: 761

  More actions

  July 6, 2010 at 12:56 am

  #234871

  Hi,

  Please see the attached document.

  Here in the attached picture “Revenue” is the MajorTypeCode, another “Revenue” is the TypeCode and the next is the “AccountNo” hierarchy.

  Here 4100 – SYSTEM SALES is the parent account and 4300 – MAINTENANCE is the child account.

  MS Local Services Income is the another parent account which does not have childs. Child accounts are 1/none/more than 1 also.

  Here 4100 has only one child account . Child accounts total amount will be showing against Parent account(4100 – SYATEM SALES).

  But when we comes to the Revenue(TypeCode) Totals, the total amount will be (-4 + -1287.99 = -1291.99) -1291.99

  but report was showing -1295.99, ie., ParentAccountAmount(4100 – System Sales) is also adding.

  Please help me how to resolve this…..

  Thanks in advance.

• ferry.jansen

  SSC Enthusiast

  Points: 196

  More actions

  July 20, 2010 at 6:43 am

  #1195462

  It's better if you add a screenshot of your design screen, not your preview screen. We can't see how the report is built like this.