Wrong sum on subitems in my calculated field (pivot table)
The sum of subitems should be 76,6% (20% + 23,3% + 10% + 23,3%) and im getting 83,3% for some reason.
3qjPqUS.png
My pivot table has two calculated fields:
-> Aderência:
=IFERROR(real/possivel;0)
-> Resultado:
= Aderência * Peso
I'm not sure why the calculated field "resultado" isn't summing right
Anyone can help me ?
Last edited by laranayrana; 05-03-2019 at 08:52 PM. Reason: Attached plan
Hello laranayrana and Welcome to Excel Forum.
I can attempt to explain/illustrate why the result is displaying as it is.
If you put the formula for Aderencia in the data table and then use it as a value field you see (Sheet2) that the subtotal is .833333
Correspondingly the subtotal for Peso_2 is 1
The value being displayed is the product of these two numbers (as per the calculated field formula), which are unseen in the pivot table on the dinamica sheet.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Oh, thank you for that. I understand it!Originally Posted by JeteMc
To get the way i want it the results i should try another approach to data, right?
In the attached file another column (Aderencia*Peso_2) has been added to the data table.
The dinamica pivot table now references that column instead of using a calculated field.
Note that the percentages are different from what was displayed previous, however when the data is checked they seem to be correct.
Let us know if you have any questions.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks