Filter pivot table dimensions to Top 10, 15, 20, etc.

[#1]

I have a dynamic pivot table that I need to add the following two functionalities to:

RowLabel1 > RowLabel2 > RowLabel3.....Revenue/Cost/GP$

SalesRegion > ProductGroup > Product.....Revenue/Cost/GP$

1. The ability to sort the data by any of the row labels and/or expression values without losing the grouping order. For example, if I want to sort descending by revenue but keep the row label groupings as defined above. Each SalesRegion > ProductGroup delineation would be maintained and the data would sort descending by Product by revenue within those groupings. Other times, however, I may just want to sort by SalesRegion, or by ProductGroup. How do I do this?

2. Is it possible to filter the data on the fly to include only the top/bottom x number of products? For example, if I want to show SalesRegion > ProductGroup > Top10Products by Revenue, Cost, or GP$?

Any help would be appreciated. Thank you!

[Anonymous]

1. See my example "Interactive sorting in Pivot Tables" in the "Sahre QlikViews section".
2. Possible - use calculated dimension based on rank function.

[#3]

Check this document on your machine C:\Program Files\QlikView\Documentation\APIguide.qwv

Most of you problem can be resolved by macros.

Here is an example for dynamic chart. http://community.qlik.com/media/p/91101.aspx

You can check other properties in the APIguide for sorting management.