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

List summary with multidimensional data

Started by f-pasquier, 21 Jan 2014 02:25:26 AM

Previous topic - Next topic

f-pasquier

Hi All,

I need to apply custom summaries to a list. The list contains many fields like Brands and Regions, and also a measure called "DeliveredQuantity". I enabled a grouping for all Brands in this list and I must show the total of DeliveredQuantity at the end of each group. In this case the total is NOT the sum of the measure values. It must come from another consolidation in my data cube.

Brands1    Europe   2000
Brands1    Asia       1000
Total Brands1         7891
where 7891 is comes from the measure "DeliveredQuantity" but located in a special consolidated Region called  "World".

I tried to add an "Intersection" (or tuple)  [DeliveredQuantity, World] with the desired elements but nothing is shown in my summary row. How can I do this? Can someone help me?