Facing issue in Total in Pivot Chart

[Anonymous]

Hey guys,

Please find the below Pivot chart table output where i m finding incorrect Total

Material	Daily Plan To (02-03-2017)
PAMM0101DN0510N	8.512
PAMM0102CP0080N	4.70504
PMAM0W32111
PMAM0W34211	5.5512
PMAM0101EG3290N
PMAM0028304	10.82385
PMAM0028357	6.564
PMAM38371DRAW
Total	413.33051
Total Should be	36.15609

Tried using Dimensionality() in the expression

IF Dimensionality()=0,(sum of the field1 + sum of the existingexpression1)

Even tried using Aggr() on the basis of Material and Date but still total is coming 413.33051 which i wrong.

Please help me to resolve the issue.

Thanks & Regards,

Girish Chhatani

[migueldelval]

Hi Girish,

Could you attach a data sample?

In my example "Total" it´s correct.

Regards

Miguel del Valle

[Anonymous]

Hi Miguel,

Thanks for the prompt reply.

Please find the attached Excel which contains the sample data along with the Expected Output.

Thanks & Regards,

Girish Chhatani

[migueldelval]

Hi Girish,

Your problem is that you aren´t managign '.' and ','; check my example and check output.

[Anonymous]

Hi Miguel,

I checked and found once i changed the Chart type to Pivot chart total numbers are changing.

Thanks & Regards,

Girish Chhatani

[Frank_Hartmann · Accepted solution]

see attached

hope this helps

[migueldelval]

Hi Girish,

Do you finally solve your question?

Please close your question or tell me if you need something more.

Regards

Miguel del Valle