partial sum not showing for expressions with aggr(sum(...

[ali_hijazi]

Hello

I got a pivot table with 4 dimensions and 3 expressions

in the third expression I'm using the aggr function to calculate the sum of fields up to the third dimension as follows:

aggr(

sum

(

{1

<

    JvdDataSource = {'SAP'},

Year = {$(=vCurrentYear)},//{$(=max(Year))},

Month = {">=$(=min({<Year={$(=vCurrentYear)}>} Month)) <=$(=max({<Year={$(=vCurrentYear)>} {$<}>} Month))"}

// Month = {">=$(=min({<Year={$(=max(Year))}>} Month)) <=$(=max({<Year={$(=max(Year))>} {$<}>} Month))"}

>

} BAJVDetails.localDebitAmount - BAJVDetails.localCreditAmount)

,BAFinanaicalCategory1.FinancialCategory1.Name)

under the 3rd dimension I checked the Show Partial sum; however this partial sum is not showing for the third expression in which I'm using the aggr function

please advise

[johnw]

I haven't tried to understand your expression, but the general form for "sum of rows" subtotals in a pivot table is like this:

sum(aggr(YourExpression,YourDimensions))

You seem to be missing the initial sum().  That would then be expected to work on the individual rows, but return null for subtotals.  So I suspect that's your problem.

[ali_hijazi]

my expression is intended to calculate the sum of (debit - credit) amounts

I have 4 dimensions A, B, C, and D

in my expression I put

aggr(sum(debit-credit), C)

the other expression is similar to the above but without the use of aggr

in the presentation tab I checked the show partial sum for dimension D

so the partial sums are shown for the columns under all expressions except for the one in which I added the aggr

if I remove the aggr function the partial sum is shown

[kaushiknsolanki · Accepted solution]

Hi,

   Try this expression.

   Sum(Aggr(Sum(Credit-Debit),C))

Regards,

Kaushik Solanki