excel 2010 pivot

In a pivot table one of my fields has a yes or no answer. The pivot table displays counts along the row in the order of No or Yes, when I'd prefer it in the order Yes or No. It does not seem possible to re-order within a pivot table. What is the best way around this please?

I need some advice on this pivot table/chart I have created. It’s my first attempt at a pivot table/chart, and I need it to accomplish two things. First: Easily compare data from test 1 to test 2 depending on a specific date. Second: a density graph where the change in density may be seen over a...

I'm working in Excel 2010. I have a pivot table that's accessible to my entire firm. The source data for the pivot table is stored within another worksheet file separate from the pivot table. I want to restrict other individuals within the firm from being able to access the source date...

I am stuck. I've created an MS Access db to pull all invoiced and quote dollars for a specific brand from April 2013 to current. My required fields are sales manager and customer name. How do I set a criteria that will aggregate the customer sales dollars greater than or equal to $75K. Then...

I have a data set that looks smth like this: <STYLE type=text/css> table.tableizer-table {border: 1px solid #CCC; font-family: Arial, Helvetica, sans-serif; font-size: 12px;} .tableizer-table td {padding: 4px; margin: 3px; border: 1px solid #ccc;} .tableizer-table th {background-color...

Hi MrExcel Board! I'm hoping you can help me. I have a pivot table set up using an OLAP Query that I need to set up a custom MDX filter for time. I need it to dynamically update to pull the last 7 days worth of data for our subset. Can you help me figure out how to change these static dates...

Is it possible to have a subtotal column to the left of the data. You can change above or below for rows, is it possible to do the same change for columns. I use excel 2010.

Hi I have loads of pivots made in Excel 2010 but almost all my users are still in excel 2003. So I need in some way make it available to them. I need help in identifing the best solution. I have some ideas but please feel free to come up with some own. Rules: 1. They don't need to be...