Calculation !!!!!

[#1]

Guys

Please   Can u give approaches for this Calculation

                  Here i want to cal calculate SLAVE  For Each respond Id By Using 101,102,103,104,105

               please find my attachment

[#2]

Why not to croos your 101,102,103.... columns into rows?

You will be able to use it as a dimension and then your calculations should be easier.

regards

Darek

[tresesco]

Like attached qvw?

[#4]

Actually i done generic load  by using for statements and left join

For calculate SLAVE Column again cross table means it will comes original status

[#5]

Sunnel,

your data model have to correspond your calculation needs.

I donk exactly know what is you 101, 102 .... fields business role, but for first sight it looks like dimension, especially if in the future you expect more of them.

In fact i don't know what problem do you have with calculation you need

regards

Darek