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?