Relative % in Pivot Table

Tue, 05 Feb 2013 15:29:50 GMT

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!

Header 1	Header 2

topic Relative % in Pivot Table in QlikView