Pivot table total error

[Anonymous]

Hello ,

I have a pivot table, the total sum of a column that contains a formula, is not correct, gives an incorrect number, in this case I should add 233 and not 208.

}

The expression of that OBJ column is the following:

if ((Country = 'BB' or Country = 'BS' or Country = 'JM' or Country = 'TT' or Country = 'AW'),

       if (TYPE_Client = 'PRES',

           if (sum (Vp) <= 208, Sum (Vp), 208), sum (Vp)), sum (Vp))

I appreciate your recommendations.

[sunny_talwar]

Try this

Sum(Aggr(

if ((Country = 'BB' or Country = 'BS' or Country = 'JM' or Country = 'TT' or Country = 'AW'),

      if (TYPE_Client = 'PRES',

          if (sum (Vp) <= 208, Sum (Vp), 208), sum (Vp)), sum (Vp))

, Representante, Ruta_O, Fuerza, Ciclo, TIPO_Cliente))

[Anonymous]

Thanks Sunny

I just make a change, but now, I am seeing values as 0 as you can see in the table.

[sunny_talwar]

Do you have another dimension in your chart? Or is any of the dimension a calculated dimension? Would you be able to share a sample to check this out?

[Anonymous]

No, any dimension is calculated,

[Anil_Babu_Samineni]

Are you labeling using Expressions? Would you mind can you attach sample? Where and why it's not working we will test for you

[sunny_talwar]

You seem to have only 4 dimensions? Again, I can only see what you share, but try this

Sum(Aggr(

if ((Country = 'BB' or Country = 'BS' or Country = 'JM' or Country = 'TT' or Country = 'AW'),

      if (TYPE_Client = 'PRES',

          if (sum (Vp) <= 208, Sum (Vp), 208), sum (Vp)), sum (Vp))

, Representante, Ruta_O, segfuerza, DesCiclos))

Basically, you need to use all your dimensions from the chart in the last line of the expression above

[Anonymous]

Hi Sunny , i forgot to thanks you, now is working fine, thank very much for your help. I like a lot this community and talk with the experts.

regards,