0 Replies Latest reply: Feb 5, 2013 10:29 AM by Robyn Talley RSS

    Relative % in Pivot Table

      I just want to create an expression that will provide be a % of the total count of presentations given per the week dimension. 

       

      I am counting the number of Presentations that are certaion plan types in a given week. 

       

       

       

      Below is the formula I am using and I am having problems. 

       

      count

      ({$<PlanDescription = {'*Life*','*Senior*'}-{'*Paid Up*','*Select*'}>} Distinct PresentationID)/

       

      count({$<PlanDescription = {'*Life*','*Senior*'}-{'*Paid Up*','*Select*'}>} Distinct total <Week> PresentationID

       

      I attached an excel verion of my pivot table in QV...my percentages appear to be off...

       

      Any suggestions would be greatly appreciated.  Thankd in Advance!

       




















































































      WeekCoverage AmountPres Cnt% of Pres
      01/17/201315k833%
      01/17/2013<15k938%
      01/17/2013>30k28%
      01/17/201330k313%
      01/17/201320k28%
      01/17/2013>15.01K<20k14%
      01/17/2013>20.01K<30k28%
      01/10/201315k829%
      01/10/2013<15k1139%
      01/10/2013>30k14%
      01/10/201330k414%
      01/10/2013>15.01K<20k27%
      01/10/2013>20.01K<30k725%
      Header 1Header 2