[Pivot Table] Add Value
http://img206.imageshack.us/img206/5285/untitledub3.gif
I would like to add value from Amount1 + Amount2 = Total (Which the amount will show at total column) e.g. 1 + 111 = 112, 1 + 222 = 223, 3 + 333 = 339, 3 + 444 = 447 My problem is certain "Amount1" column is blank and my result will add with "0" and not "1, 3..." Anyway to resolve this?? |
All times are GMT +1. The time now is 02:58 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com