Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Girish,
Could you attach a data sample?
In my example "Total" it´s correct.
Regards
Miguel del Valle
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
Hi Girish,
Your problem is that you aren´t managign '.' and ','; check my example and check output.
Hi Miguel,
I checked and found once i changed the Chart type to Pivot chart total numbers are changing.
Thanks & Regards,
Girish Chhatani
see attached
hope this helps
Hi Girish,
Do you finally solve your question?
Please close your question or tell me if you need something more.
Regards
Miguel del Valle