0
votes
1answer
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
0answers
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
1answer
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
3answers
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
1answer
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 ...