# Tagged Questions

**0**

votes

**3**answers

41 views

### In Excel PivotTables, how do I show items that occur in one category but not another?

Simplified version of my data:
item category number
apples fruit 7
orange fruit 2
tomato fruit 3
tomato vege 9
zuchini vege 2
tomato vege 17
...

**0**

votes

**0**answers

32 views

### calculated column in pivot table from power pivot

From SQL server I have a query that gives me daily transaction numbers for few companies per day, something like
DATE Company Total Tax year
2013-04-24 ABC 50 2013
...

**2**

votes

**1**answer

29 views

### Auto formatting new pivot rows to data bars

I have a pivot table that takes data from database and displays it as a data bars. Problem is, that the data is updated daily - every day new row is added so the pivot table is growing. Unfortunately ...

**0**

votes

**0**answers

79 views

### Listing/grouping variables in pivot table field list

I have data with 60+ variables and I would like to group the variables into different collapsible fields in pivot table similar to having different tables in the pivot field list instead of having all ...

**0**

votes

**1**answer

27 views

### Getting #NUM! for outer nests of IF statement division

I have some sales figures for which I have values in pounds, units, and dollars. From PowerPivot, I'm creating a pivot with Periods columns (Current Week, MTD, QTD, YTD) and sub-columns of "Measure" ...

**0**

votes

**0**answers

62 views

### Why is my excel 2013 pivot table not sorting properly on % differnce

I have a pivot with the following:
Categories running down the rows
Columns with a count in for each category for each quarter last year, say number of jobs in each category for each quarter.
When ...

**0**

votes

**1**answer

280 views

### Calculating Annualized Turnover in a Pivot Table or PowerPivot

I'm trying to calculate employee turnover where the numerator is annualized only for the current incomplete year.
The closest I have gotten is TER/HC as a calculated Field in a pivot table. This ...

**3**

votes

**3**answers

5k views

### Excel 2010 PowerPivot: How to show items with no data?

In standard Excel pivot tables, there is an option for fields that allow you to force display of all items even if there are no results for your current selection. Here's the option:
However, using ...

**1**

vote

**1**answer

635 views

### Excel PivotTable % of a specific value

My users have a hand built report showing tickets by time frame and their priorities.
Priority Count
1 68
2 41
3 61
N/a ...