Quote:
Originally Posted by inreality01
1) Why am I getting blanks in the Jurisdiction drop-down but not the Incident drop down?
|
This is addressed above. If you go to Data: Data Validation for each and look at the specified ranges, you will see why.
Quote:
|
2) Are there any specific issues I need to worry about when formatting the Pivot Table? i.e. Changing the fonts, colors, etc. Will they carry over as the Pivot Table changes? I will obviously do some testing but thought I would ask as well.
|
Up on your ribbon to the right, you will see Pivot Table Options with tabs for Options and Design there. Options will let you modify the data displayed. Design allows you to format how they are displayed. Use the canned formats under Design.
Quote:
|
The Log tab can be sorted by any column.
|
As I've use the Format as Table functionality here, there are lots of things you can do. Sorting or even filtering right on the data table. For example, click the filter doohickey for any one of the columns with dates. You can select specific months or years, or even filter by Last Quarter and Year to Date.
01-06-2016, 10:33 AM
Similar Threads
Excel, transfer data from Master Sheet to sub sheets, using key word from column
Windows 7 64bit 
Office 2010 64bit
Threaded Mode