Pivot Table Questions

A

Adam

I have a standard data sheet with dates, info, and
website. I have built them into a pivot table but have
had some problems formatting it. it llooks like this

date Category Link
3/4/03 NEWS http://www.link.com
3/5/03 NEWS http://www.link.com
NEWS http://www.link.com
3/6/03 NEWS http://www.link.com

now my problem is that the dates do not show up in every
entry. The third entry down should say 3/5/03 but since
the one above it is the same date it automatically omits
it. I can find no way to fix this. Second, the link in
the pivot table is not a hyperlink. The original data has
hyperlinks but when coverted into a pivot table it only
shows the text. Is there even a way to make hyperlinks in
a pivot table? Any help would be greatly appreciated.
Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table Hyperlink 0
Pivot table Days to Months 0
Pivot Table with Data Model Connection - getpivotdata reference issue 0
Pivot Table Data Aggregation 0
DATE Calculations in pivot table 0
Pivot Table Summary Error? 6
Pivot Table and Merged Cells Help 1
Formula for multiple rows of same value... 2

Top