How to put an input field for scenario analysis

[Maroine Jbili]

I'm askingagain a question for which no answer was given.

Here's the question :

Let me explain; Let's say I have my sales numbers for a quarter per country e.g. in Q3 I have 3000 sales in Poland. This is what Spotfire's Cross table shows me. I would like to create a column next to this, which operates as an input column (like in excel, you could put numbers). I want to do an easy calculation for the best, the realistic and the worst scenarios by typing a number to these input cells so it adds up in the end.

3000 + ''input field'' 2000 = ''best case scenario'' 5000.

OR

Instead of using Text area I would like to write a comment next to the respective data in an empty column.

Is there any way to create an expression or something, which is able to visualize this kind of thing

I am wondering if I could insert a field for multiple rows to calculate independently.

Many thanks in advance,

 

 

 

Quarter

Sales

Input

Best case scenario

 

 

Q1

10 000

500

10 500

 

 

Q3

2 000

400

2 400

 

 

Q2

4 000

0

4 000

 

 

Q2

3 000

300

3 300

 

 

Q4

200

7000

7 200

 

 

Q1

1 000

600

1 600

 

 

 

20 200

 

20 200

[Prashant Ajjannavar]

Hello,

I guess it is possible through document property.

Can you take a look at below-attached dxp and share your comments.

 

Regards,

Prashant