Next privilege 200 Rep.
See reduced ads
Next badge 0/1
~664 people reached
- 0 posts edited
- 1 helpful flag
- 1 vote cast
Can I force an Excel 2010 Pivot-Table to display text strings from my raw data?
Is there a way to force Excel 2010 to make it's pivot tables display the actual values of cells in your RawData while filtering for a specific subset?... Double click on the value.. new sheet with raw data making up that value.
How to merge multiple value cells in excel
stackoverflow.com/questions/17240052/… answers for both vba and non-vba provided
Sort Excel Pivot Table By Month
Filter it out of the raw data before the pivot see's it. I believe if you filter the data then refresh the pivot the date will fall off or be just that date...