straight table

[#1]

Hi,

I have  straight table like bellow

segments	values
D1	10
D2	20
D3	30
D4	40
D5	50

here i need to sum first four , i dont want last one how can we do ,can any one help me

Thanks,

Jyothi

[#2]

Hi,

Try this in expression part of staight table:

   =sum({ $< segments = E({ 1<segments={'D5'}> }) > } values )

but it will not show you the whole row of D5 segments.

Apurva

[jagan]

Hi Jyothi,

Put Segments in Dimension, and use expression

=If(RowNo() <=4, Values, Null())

and in presentation tab limit Number of rows 4.

This shows only 4 rows in the straight table.

Regards,

Jagan.

[#4]

Hi I have Used the same example of Jagan but with little modifcation.

I have use the variable and input box.

Now you can dynamically change your range as per your requirement.

Regards,

Nitin Jain

[#5]

Thanks you for you replay apurva

Thanks,

Jyothi

On Thu, Dec 8, 2011 at 11:45 AM, Apurva ... <

[#6]

Thank u so-much Jagan

R u happy

On Thu, Dec 8, 2011 at 11:56 AM, jagan mohan <