Thread: Value not showing in pivot table
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
  
Posts: 9,221
Default Value not showing in pivot table
.. then swap EFT for EFT1 in your pivot's layout.

You probably need to extend the pivot's source range
to include the helper col D first before you can swap
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,500 Files:362 Subscribers:62
xdemechanik
---

Reply With QuoteReply With Quote