Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Can you post sample app and expected output