How to do a "Top 10 selection"

Discussion forum for PivotCube VCL users. Common questions. Bug and problem reports

Moderator: Alex Zencovich

How to do a "Top 10 selection"

Postby kurgbe » Wed Aug 23, 2006 7:52 am

Is it possible to view only the top 10 biggest value for a given measure?

Imagine you have the sales figures per vendor and you only want to see the best 10 sales persons.

I tried "the Filter by map cells" but it seems to filter only on the "Value' of the measure and not on the "Ranlk(by row)" value.

Any idea?
kurgbe
User
 
Posts: 14
Joined: Thu Aug 03, 2006 8:35 pm

Postby AlexZencovich » Wed Aug 23, 2006 8:38 am

See demo. It has a several examples which can help with this. See <Advanced> menu in demo
Best regards,

Alex Zencovich
-------------------------------------------------------------------------------------------------------------------------------------------
www.pivotcube.com - OLAP solution for Delphi, C++ Builder and ActiveX environment
AlexZencovich
Site Admin
 
Posts: 580
Joined: Sun Jun 18, 2006 10:09 am

Postby kurgbe » Wed Aug 23, 2006 1:30 pm

Thanks for the reply. Can you confirm that standard "Filter by maps cell" function always refer to the VALUE regardless of what is being shown in the actual cells. So if I set MinValue to 50, and the view is by "Percentage by ROW", Pivotcube will filter on the value and not the percentage.
kurgbe
User
 
Posts: 14
Joined: Thu Aug 03, 2006 8:35 pm

Postby AlexZencovich » Wed Aug 23, 2006 2:11 pm

Yes. You are right. Filter on map cells always filtered by value (View type - mvValue)
Support for filtering by view value will realized in next major version
Best regards,

Alex Zencovich
-------------------------------------------------------------------------------------------------------------------------------------------
www.pivotcube.com - OLAP solution for Delphi, C++ Builder and ActiveX environment
AlexZencovich
Site Admin
 
Posts: 580
Joined: Sun Jun 18, 2006 10:09 am


Return to PivotCube VCL

Who is online

Users browsing this forum: No registered users and 2 guests

cron