Prev: Help with Table, Please!
Next: formular
From: suziep on 18 Feb 2010 19:32 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
From: Debra Dalgleish on 19 Feb 2010 20:26 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. suziep wrote: > 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 >  Debra Dalgleish Contextures www.contextures.com/tiptech.html Blog: http://blog.contextures.com

Pages: 1 Prev: Help with Table, Please! Next: formular 