If you look at the pivot table below you will see that at week 14 the revenue is 2,552,888 but that is not true...the 2,552,888 does not include the 2,458 for Private LVC (2nd row) or the 143,799 TOD, or the 106,066 Public Inclass...how can I make these blank cells carry the same amount as the week before even though there is not revenue for that week ?
Thanks
