Calculate difference between two rows of list box

[sujit_nath]

I have a column containing 2 values which I am using as a dimension in my pivot table chart.

The chart has one expression. Now I want a third row to be added into that column that will be the difference of second -first row upon calculation.

Column1

feild1

feild2

feild2-feild1 (Currently I do not have this feild. I want to add this feild so data will be populated id I use this column1 as dimension)

[gayathridevi24]

Hi Sujit,

Could you please provide some examples.

[Jesh19 · Accepted solution]

Try checking the ValueList/ValueLoop concept.

[Kushal_Chawda · Accepted solution]

Create one inline table in script as below

Load * Inline [
Dim
1
2 ];

then in chart add below dimension and measure

Dimension:

=pick(Dim,Column,'Field3')

Measure:

=pick(Dim,sum(Sales),sum({<Column={'Field2'}>}Sales)-sum({<Column={'Field1'}>}Sales))

[sujit_nath]

Hi Kush,

Thanks for the solution, I tried with Valuelist though, and this gives me my desired result.

[sujit_nath]

i Jesh,

I achieved the solution through this. thanks alot!!