Hi!
We want to use the cube views in Thinkwise (Windows) to monitor our KPIs. One of these cube views is the representation of the company’s margin. The cube view is built based on a view, and this view is shown below the graph. I have created a ‘dummy’ table and a graph in Excel, which represents the view shown for the user. The formula for the margin KPI is as follows:
100 * (sum(invoicedi€]) / sum(margin u€]))
Our users would like the following:
- The KPI calculation should be based on what the view is currently showing. This means that the calculation is ‘triggered’ (process flow?) when the user starts filtering in the view.
- The result should be shown near the margin view (or ideally, implemented in the graph). But it can also be a value stored in another table.
Is it possible to start a process flow where I can fetch the shown data (e.g. order_id; financial done dates and order category) in the view when the user starts filtering? I know that the layout is triggered every time the user clicks on a cell or starts filtering.
![](https://uploads-eu-west-1.insided.com/thinkwise-en/attachment/1e6444a9-cd7a-48a7-a7e1-5136fd092958.png)