Skip to Content
May 15, 2016 at 09:12 PM

Best Solution to get data



I have data in MyCalculationView like below,

IITEM VALUE X1 10 X2 25 X3 12 X4 40 X5 90 X6 55

I want to create MyCalculationView to get X7, X8, X9, X10 and it's formula will be:

X7 = (X1 / X3

X8 = (X1 * X3)

X9 = (X2 / X5)

X10 = (X6 / X3)

and I've two solutions to get my desired resullt

  1. Creating restricted column in MyCalculationView for each X1, X3, X2, X5, X6 and then reused my calculation view in another one to be able to calculate the columns
  2. Reuse MyCalculationView in other one four times with adding filter in ITEM column.

but I believe neither of two solutions is best practice.

So what is the right thing I should do.