Problem in Creating Sectional Report

building reports webintelligence
1

Hi!

I am facing a very strange problem while creating a report.
I am creating a report which I need to divide in sections based on Product Groups.
The table structure is like this

Year | Product Group | Items Sold | Items Unsold | % Sold | Total Items

And then what I did is I simply drag the Product Group column to create a section on it. and then copy the remaining table outside section to get the total data of all product groups.

But when I calculate the sum of all product groups in each section and compare it with the total in the table outside the section, the result differs.

Thanks to guide me where I am doing wrong or how can I achieve the desired results.

Regards,
Sanjeev

sanbatra :india: (BOB member since 2006-09-29)

2

Hi,

Please see the attachment. Are you creating sections the same way?

Thanks,
srujana
SectionSum.doc (113.0 KB)

srujanaj :india: (BOB member since 2010-02-10)

3

Yes!
It is more or less on the same lines in whcih I am creating the report. But in the last I need only the aggregate and not the rows for every record.

Please see the actual report saved in Excel.

Here the total is different if we do the sum from each section.
NotificationsTreated_(Product_Group).xls (107.0 KB)

sanbatra :india: (BOB member since 2006-09-29)

4

It cud be because the same notificaton is counted under multiple sections.
where as in total section distinct notifications are considered.

pravin14 (BOB member since 2008-11-20)

5

Hi, Thanks for your reply but it can’t be the case as one notification will belong to one group only and can not belong to another group. So every notification is mutually exclusive among all the groups.

sanbatra :india: (BOB member since 2006-09-29)

6

Hi,

I see there is a section on Total. What is that variable ?
Try creating an aggregate for each table (see my attachment).

-srujana

srujanaj :india: (BOB member since 2010-02-10)

7

Thanks for your replies. But there is no section on Total. Total is outside the section created on the product groups (e.g APG etc).
If you are talking about the column Total Notifications then that is the Sum(Count[Id])).

sanbatra :india: (BOB member since 2006-09-29)

8

Can you try Count([ID]) In Report

pravin14 (BOB member since 2008-11-20)

9

@ pravin14

Thanks pravin14 for pointing towards duplication of records in various groups. However I was under impression :shock: that the id is unique across groups but it is not the case and one id is repeating in many groups and total is counting the distinct record.

Thanks all for your help and support.

Have a nice weekend.
-Sanjeev

sanbatra :india: (BOB member since 2006-09-29)