lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
Hi
I had simple table like the one below. I created a pivot table from that table. I do not know what I did, I got some DIV# values. I know that error message when you divide by 0 but I did not have any calculation or anything, I do not know what happened but I got the #div error . I have been trying to re-produce the situation but no success. Do you have an idea why I got that error message in pivot table when I did not any calculation? Thank you so much.
I had simple table like the one below. I created a pivot table from that table. I do not know what I did, I got some DIV# values. I know that error message when you divide by 0 but I did not have any calculation or anything, I do not know what happened but I got the #div error . I have been trying to re-produce the situation but no success. Do you have an idea why I got that error message in pivot table when I did not any calculation? Thank you so much.
name | store | item | amount | month |
mary1 | east | tv | 265 | jan |
mary2 | west | computer | 641 | feb |
mary3 | south | printer | 109 | mar |
mary4 | north | tv | 193 | jan |
mary5 | east | tv | 0 | jan |