prob with sum

[#1]

Hi and a happy new year!

i have got a problem with the sum in a pivot table.

my dimensions are

attribute|SalesID|ItemID

my columns are

1. sum(QTYORDERED)

2. sum(lineamount)

3. FirstSortedValue(COSTPRICE,MODIFIEDDATETIME_INVENTTABLEMODUL)*sum(QTYORDERED)

4. sum(lineamount)-FirstSortedValue(COSTPRICE,-MODIFIEDDATETIME_INVENTTABLEMODUL)*sum(QTYORDERED)

my problem is in the 3. and 4. column

i need the sum of them only shown for the first dimension (attribut) i have 10 attributes so i want to see the sum of these 10 rows but it doesnt work only when i show all rows for itemID

has anybody an idea?

[anbu1984]

Can you post sample app and expected output