different total in pivot table

[Anonymous]

Hi,

My problem is that in a pivot table that I have 5 amounts of 9,000,000 in an expression, but the total seems 16,000,000.

I no have idea how to change.

I hope you can help me.

[swuehl]

In a pivot, the total is calculated as expression total.

Depending on your data and expression, the result differ from a sum-of-rows.

To get a sum-of-rows, use advanced aggregation:

sum( aggr( YOUREXPRESSION, YOURTABLEDIMENSIONS))

and please have a look at the Help, search for sum-of-rows in pivot tables.

Hope this helps,

Stefan

[Anonymous]

but the problem I have is that the sum of columns (expressions) is not the total, as shown in the image attach, the problem is not the sum of the rows.

thanks for helping

[#4]

Can you upload a sample?

[swuehl]

Maybe I miss your point, I only see one column and a total for that, so I assumed that's the total over the rows.

What value do you expect as total? As Federico said, could you upload a sample or at least state your expressions / dimensions used?

[Anonymous]

ok, I have this expression

if( MaxString({$<Reporte= {[Balance]} >} Rubro1)= 'Total de Activo',

If(    Dimensionality()<=Max(    {$<    $(vSetModoVista) /*La variable incluye coma*/

                                $(vSetMTDHist),

                                Reporte =    {[Balance]}

                            >} Dimensionality

                        ),

    Sum    (    {$<    $(vSetModoVista) /*La variable incluye coma*/

                $(vSetMTDHist),

                Reporte =    {[Balance]}

            >}

            (([$ Importe ML (Original)]*Signo) * Factor)/Divisor

                )

),

If(    Dimensionality()<=Max(    {$<    $(vSetModoVista) /*La variable incluye coma*/

                                $(vSetMTDHist),

                                Reporte =    {[Balance]}

                            >} Dimensionality

                        ),

    Sum    (    {$<    $(vSetModoVista) /*La variable incluye coma*/

                $(vSetMTDHist),

                Reporte =    {[Balance]}

            >}

            (([$ Importe ML (Original)]*Signo*(-1)) * Factor)/Divisor

                )

)

)

I'll try to post an example