Sep 10 2021 08:03 AM
Desperate -- i've tried all tips I've seen, not sure what to do anymore. I am getting zeros in my pivot table from the amount row -- i've made sure it's not text and the spreadsheet isn't set to manual calculate. what am I missing? thank you so much.
Sep 10 2021 08:07 AM
Solution@las751875 All your amounts are texts. Transformed them to numbers with "Text to columns". Now all works.
Sep 10 2021 08:34 AM
Sep 10 2021 08:07 AM
Solution@las751875 All your amounts are texts. Transformed them to numbers with "Text to columns". Now all works.