# Tagged Questions

**0**

votes

**1**answer

19 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

16 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

153 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

2k 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

574 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 ...