tschuman13
Programmer
I have run out of ideas and I need help with a report that is 95% complete. I am using a PowerCube and C10.
Some background info:
Dimensions in the cube (for specific report) are:
Group -> Company -> Issuer
State
Coverage Type
Measures (for specific report)
Group Category Count
Premium Amount
I am using a list report due to the requirement to show a "text/string" value in the body of the report.
The report has the following columns:
Coverage Type (Group By) / State Name/ # of Groups in State / Name of Largest Group / % Premium of Largest Group/ % Premium of 3 Largest Groups/ # of Groups that make up top 90%
I have everything working except for the Name of Largest Group. When I try to calculate this, I can get the right value but all other calcs break and give just the value for the largest group. The function I am trying to use is:
item(TopCount(set of Groups, 1, Premium),0)
The function I am using to get the other values are variations of this:
aggregate(Premium within set(topCount(Groups,1,Premium)))
count(1 within set(topPercent (Groups,90,Premium)))
So it looks like the within set scope keeps the report from filtering all results. Is there a way to bring back the 1st member and display it in the same report?
Thanks in advance for any help!
Some background info:
Dimensions in the cube (for specific report) are:
Group -> Company -> Issuer
State
Coverage Type
Measures (for specific report)
Group Category Count
Premium Amount
I am using a list report due to the requirement to show a "text/string" value in the body of the report.
The report has the following columns:
Coverage Type (Group By) / State Name/ # of Groups in State / Name of Largest Group / % Premium of Largest Group/ % Premium of 3 Largest Groups/ # of Groups that make up top 90%
I have everything working except for the Name of Largest Group. When I try to calculate this, I can get the right value but all other calcs break and give just the value for the largest group. The function I am trying to use is:
item(TopCount(set of Groups, 1, Premium),0)
The function I am using to get the other values are variations of this:
aggregate(Premium within set(topCount(Groups,1,Premium)))
count(1 within set(topPercent (Groups,90,Premium)))
So it looks like the within set scope keeps the report from filtering all results. Is there a way to bring back the 1st member and display it in the same report?
Thanks in advance for any help!