If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Master-Detail Help Needed

Started by bloopaman, 30 Aug 2013 11:50:18 AM

Previous topic - Next topic

bloopaman

All,

Relational data source.  I have a requirement to produce a report which produces a page per distinct value in a column.  On each page I need to show the sum of some columns for the distinct value selected, and the remaining, in cross tab columns.  I need to be able to do this with master detail relationships I believe, but I can only "FILTER" to display items pertaining to the master item  selected for the page.  I have no idea how to get the remaining.  For example, I have the following data:

GROUP, VALUE
A, 10
B, 10
C, 10

I need a cross tab that appears like:
            A       Remaining
Value   10      20

...and on the next page
            B       Remaining
Value   10      20


ETC.  Please help!

RKMI

Hi,

I think this can be done in list using section.

First add a new data item ( Total Group) and the calc as  total([value]) - total( [value] for [group]), that should give you the following.

GROUP, VALUE, Total Group
A         , 10      ,50
B         , 20      ,40
C         , 30      ,30

After which you can section the list for the group and then set pagebreak on group so that it appears on its own page.

Hope this helps.

Thanks,
RK

bloopaman

#2
Except I don't want to show the totals... I want to show the remaining.

And just to clarify, I need to display the measures along the rows.  So
                     A   Remaining
VALUE1        10              20
VALUE2        10              20

--------- PAGE BREAK

                     B   Remaining
VALUE1        10              20
VALUE2        10              20


Lynn

Quote from: bloopaman on 30 Aug 2013 01:38:38 PM
Except I don't want to show the totals... I want to show the remaining.

And just to clarify, I need to display the measures along the rows.  So
                     A   Remaining
VALUE1        10              20
VALUE2        10              20

--------- PAGE BREAK

                     B   Remaining
VALUE1        10              20
VALUE2        10              20



Look again at the expression RK gave you and the data example provided.

total([value]) - total( [value] for [group])

That looks to me like it will give you the remaining amount you want.

bloopaman

#4
No, the calculation is not working.  This is a relational datasouce and the query....

total(Value) - total(Value for Group) is simply evaluating total(Value) and total(Value for Group) to the same number and producing 0.  Replacing the expression left of the minus sign with Total(Value for all Group) has no effect. 

How do I get the measures along the left side going down with a list through?

RKMI

Hi,

What mentions is correct. It suppose to be remaining value sorry named it wrong.

I'm also using a relational model, here is a my expression below,

Total( [value] for report) - total( [value] for [Group])

I forgot to add the for report in the first total.

Thanks,
RK