##
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]

## 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]

## Calling all Excel PivotTable Gurus

How do I construct this PivotTable to show what I need? [more inside]

## Creating a basic custom PivotTable style in Excel 2010

Any good resources for help in creating custom PivotTable styles in Excel 2010? [more inside]

## Very Specific Spreadsheet Question: Ranges

How do you make Excel automatically group years (1921, 1925, 1929) into decades (1920s)? [more inside]

## 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]

## 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]

## 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]

## 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]

## Excel, Pivot, Dates.

Excel - Pivoting With Dates [more inside]

## 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]

## 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]

## "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]

## How to compare multi-row averages in JMP?

How do I compare averages in JMP (statistical software)? Help me stop using Excel. [more inside]

## Applescript+Excel+Pivot Table

Applescript + Excel . How to suppress subtotals for a field in a pivot table? [more inside]

## 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]

## PivotTableFilter

PivotTableFilter: Can I have columns by month if I have the full date? [more inside]

## Pivot Tables in Excel

Is there a way to prevent a Pivot Table (in Excel) from displaying a row with all zeros? [more inside]

Page:
1