Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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.
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
Thanks you for you replay apurva
Thanks,
Jyothi
On Thu, Dec 8, 2011 at 11:45 AM, Apurva ... <
Thank u so-much Jagan
R u happy
On Thu, Dec 8, 2011 at 11:56 AM, jagan mohan <