18 posts tagged with pivottable.
Displaying 1 through 18 of 18. Subscribe:

Excel PivotTable filter: how to calculate percentage?

One field, FieldA, is being summed in a column. Another field, FieldB, is being counted in a column. How do I get FieldA/FieldB as a percent in the pivot table? [more inside]
posted by bologna on wry on Jan 6, 2017 - 5 answers

Need spreadsheet with pivot tables, but can't really use Excel or Sheets

We have a very large Excel spreadsheet with a lot of raw sales data. I'm then creating pivot tables to look at the info in various ways to help our sales team. However, we're bumping into some severe limitations with regards security, sharing, and user-friendliness of the UI and trying to figure out if there are alternatives. [more inside]
posted by edjusted on Dec 6, 2016 - 15 answers

Calling all Excel PivotTable Gurus

How do I construct this PivotTable to show what I need? [more inside]
posted by bologna on wry on Sep 14, 2016 - 3 answers

Creating a basic custom PivotTable style in Excel 2010

Any good resources for help in creating custom PivotTable styles in Excel 2010? [more inside]
posted by undercoverhuwaaah on Jul 9, 2012 - 4 answers

Very Specific Spreadsheet Question: Ranges

How do you make Excel automatically group years (1921, 1925, 1929) into decades (1920s)? [more inside]
posted by goatdog on Jun 19, 2012 - 7 answers

Can I create pivot table from subset of data?

Can I create pivot table from subset of data? If not, is there another way to do what I want to do? [more inside]
posted by Diablevert on Nov 20, 2011 - 6 answers

My googles are failing me

Is there a quick and easy SAAS program I can use that replicates the functionality of MS Excel pivottables but on the web? [more inside]
posted by jourman2 on Mar 14, 2011 - 6 answers

A text based pivot table

Excel Assist/I don't believe I couldn't figure this one out: I have a table with unique text values. How can I have it act the same way as a pivot table? Sample inside. [more inside]
posted by yoyoceramic on May 17, 2010 - 9 answers

Can you help me construct a slightly complex Pivot Table in Excel?

Can you help me construct a slightly complex Pivot Table in Excel? [more inside]
posted by willnot on May 14, 2009 - 6 answers

Excel, Pivot, Dates.

Excel - Pivoting With Dates [more inside]
posted by SirStan on Mar 25, 2009 - 3 answers

Pivot Tables for Dummies?

Pivot Tables for Dummies? Can anyone recommend a good tutorial for pivot tables for someone who's never created them before? [more inside]
posted by nooneyouknow on Sep 8, 2008 - 3 answers

Is there an easy way to break pivot table rows or pages down into non-linked workbooks

I have an Excel pivot table for sales performance data. I want to break that down for regional managers so that they only have access to their own offices' data while preserving the nice formatting that the pivot table provides. Is there an easy way to do that? [more inside]
posted by willnot on Aug 20, 2008 - 3 answers

"Sum of Total Cost" is redundant; I said "Total", didn't I?

Excel 2007: How do I get "Sum of" out of the data headers of my Pivottable? [more inside]
posted by skryche on Jul 28, 2008 - 4 answers

How to compare multi-row averages in JMP?

How do I compare averages in JMP (statistical software)? Help me stop using Excel. [more inside]
posted by dmd on Jul 22, 2007 - 8 answers

Applescript+Excel+Pivot Table

Applescript + Excel . How to suppress subtotals for a field in a pivot table? [more inside]
posted by cdavis on Jul 12, 2007 - 2 answers

How do I get totals in a pivot table in SQL?

I have an SQL query that totals the number of students per grade. How do I get a grand total of the number of students? [more inside]
posted by DakotaPaul on Mar 17, 2006 - 6 answers


PivotTableFilter: Can I have columns by month if I have the full date? [more inside]
posted by pithy comment on Jan 13, 2006 - 17 answers

Pivot Tables in Excel

Is there a way to prevent a Pivot Table (in Excel) from displaying a row with all zeros? [more inside]
posted by grateful on Aug 10, 2005 - 10 answers

Page: 1