% of subtotal in pivot tables

S

suziep

Hello
Does anyone know of a way I can create %s of subtotals in a pivot table -
instead of % of grand total. I need to create a table from a cube which has
salary by region over time with the number of people in each salary range as
a percentage of the region. I have tried using the % Of setting but it comes
up with nonsense values of itself, ie. each salary range is 100%.
Cheers
 
D

Debra Dalgleish

There's no % of subtotal feature in a pivot table. Perhaps you can
arrange the pivot table so the data you want to subtotal is shown in
separate columns, then calculate the % of column.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Average of Subtotals in Pivot Table 0
Calculating Average Salaries with Three Other Variables - Pivot Tables? 2
Pivot table calculated field 2
Subtotal the median 1
about pivot table 1
Subtotal based on a range of data in Pivot Table 5
Formula Instead Of A Pivot Table 8
Formula, Pivot Table, ??? Beats me 2

Top