Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!