Filter Pivot Table by Cell Format

This can actually be done, if you have the right data in your table. The trick is to create a pivot table in a tabular view with no more than one value column, if at all possible. If you can do that, you should be golden to embark on the magnificent task of being able … Continue reading

Time Reporting Queries (it’s about time)

One of the things I feel a bit like a pioneer about (seriously, it’s pretty similar to churning your own butter) is time reporting. Specifically when it comes to task level status for time reporting from the reporting database. In this post I will include two helpful queries for time reporting – one for timesheet … Continue reading

SharePoint Required Site Columns are a Jerk!

The problem: You have a content type template saved on the server and tied to the content type.  The content type has required fields.  To leave the fields blank, you have to change the content type fields to “optional” in order to make updates to the template.  When you have a huge site collection with … Continue reading