Recent content by stefaniejo

Whenever I double click in one of the cells in my pivot table to display the source data behind the number it pulls up a new sheet with all of the data for the column. Example: There are 7000 total records showing shipment information. One of my columns in the Data sheet shows the month...

One of my customers made a funky request. When calculating date ranges on their report they want to calculate calendar days but count Saturday and Sunday as 1 day. Example: My start date is Wed, 1 Jun and my end date is Tue, 7 Jun. Wed counts as day 0, Thu counts as day 1, Fri day 2, Sat &...

Awesome!!! That worked! :) I didn't even think to check that.

One of my customers is complaining because the filter lists on the PivotTable are not in alphabetical order. New data values have been added to the data since the PivotTable was built, and all of the new values show up at the bottom of the filter. Is there a way to re-alphabetize the list...

I'll give it a whirl and see if it works...

I'm trying to count the number of occurrences of a specific field, but I have some instances when the primary indicator is duplicated. For the first occurence I want to show a 1 and for everything else I want to show 0. I am sorting by the field so that all occurences are together. Is this...