Looking for solution

[Anonymous]

Hello everyone,

im looking for solution, in the image you can see my steps and my goal.

Information for Start:
- is / plan / diff are measurements for NAME

Information for NOW:
- still measurement
- i create *-* relationship between a tabel NAME and new table witch include is / plan / diff

Information for Goal:
well this ist what i´m looking for. Maybe wihtout *-* (n-m) relationship in an Matrix.

Thanks for your ideas!

[Anonymous]

One more try to find a good idee here.

My problem is, that for calculation in original model BPI needs only 8 seconds, in new solution it needs 30 seconds.

[Anonymous]

Well, in my model is it build up this way.
I have data with is and i have separate data with plan, they all have relation to name.
Now, i´m comparing different cases for name for is, plan and calculate the differences.

As You can see in my post 1, i have started with simple table, then i change my model little bit...

so i build up a simple sheet with
value in 1 column: is, plan, difference
and build up a matrix.

but i´m not happy like you see, my goal should be much better for visualisation.

[amitchandak]

@Anonymous ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.