Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

TopCount Help!!!

Status
Not open for further replies.

tschuman13

Programmer
Aug 10, 2012
1
US
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!


 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top