Sum calculated dimension

[gf]

Hello all,

is it possible to display subtotals for calculated dimension in a pivot table.

Or is there any other solution with straight table to achive this outcome.

For calculated dimension Betrag_Abgrenzung, Betrag Bilanzbuchung, Differenz and Veränderung should the subtotals be displayed. 

[zhadrakas]

Hello,

I think you are using complex Expression here. That should be the reason why there is no subtotal.

i would recommend to wrap an sum(aggr(Your_Expression, your_Dimension)) around it.

regards

tim

[gf]

I tried
=SUM(AGGR(NUM(BETRAG_ABGRENZUNG,'##.###,##'),UK,SK,SUBKATEGORIE,ZE,ZNR,KOST,BK,KOA,J,N,U,SV_ID,C,T,AEK,K,X,M,BETRAG_ABGRENZUNG))
as calculated dimension.
But i get an error.

[gf]

Also
=SUM(AGGR(SUM(DISTINCT BETRAG_ABGRENZUNG),BETRAG_ABGRENZUNG))
doesn't work.

[Anil_Babu_Samineni]

@gf  Perhaps this?

SUM(AGGR(NUM(Sum(BETRAG_ABGRENZUNG),'##.###,##'),UK,SK,SUBKATEGORIE,ZE,ZNR,KOST,BK,KOA,J,N,U,SV_ID,C,T,AEK,K,X,M,BETRAG_ABGRENZUNG))

[Anil_Babu_Samineni]

Since it is calc. dimension - Sum() never work. Perhaps this?

AGGR(NUM(Sum(BETRAG_ABGRENZUNG),'##.###,##'),UK,SK,SUBKATEGORIE,ZE,ZNR,KOST,BK,KOA,J,N,U,SV_ID,C,T,AEK,K,X,M,BETRAG_ABGRENZUNG)

[zhadrakas]

I would Keep the Expression like this but add it as Expression and not as dynamic Dimension:
You will not get the subtotals in dynamic dimensions. Only in Expressions.
=SUM(AGGR(NUM(BETRAG_ABGRENZUNG,'##.###,##'),UK,SK,SUBKATEGORIE,ZE,ZNR,KOST,BK,KOA,J,N,U,SV_ID,C,T,AEK,K,X,M,BETRAG_ABGRENZUNG))
Repeat this for the other 3 dynamic dimensions

[gf]

Thanks for your answers!
@tim the problem is i want the columns to stay in their original position. As far as i know expression column will only show at the end of a pivot table.

@Anil_Babu_Samineni your expression works but subtotals won't display

[zhadrakas]

You are right. thats not possible in Pivot table.
But in straight table you can do that

[gf]

May you have a look at my sample data.