for our development data model we would like to dive into our top X (e.g. 100) of open development projects in regards to their expected value. Currently I only know the function for an OLAP-table to show a limit number of rows. If we filter on certain areas/regions/plants this option remains, always showing the top X for the current selection. But we need additionaly KPIs above the table as:
- Total expected value of the top X projects
- Certain Process-KPIs like (Average development loops per project) etc.
Now I’m searching, if there is any functionality to put a component filter or sheet-filter that we respect only the top X projects of the current selection.
This might be interesting for everyone who want’s to have a look/comparison within their top X cases.