Requirement on table box

[#1]

Hi

i have table box in that i have 5 fields

for example:

City            population     Growth   P%   Status

London,          22000          2%     1%     Green

New York        12500          1%     0.5%   yellow

Spain               52000         29%   5%    Green

Delhi               1300             0%    2%    Red

Hyd                  15000          5%    1%    green

i have to display only last 3 records  how to do this .i am using table box here

Thanks

[sunny_talwar]

Is there a reason you want to do this in table box? Straight table won't work? and why the last 3 records? What is so unique about them?

[swuehl]

Select Spain, Delhi and Hyd

You can't use expressions or filters in the table box object, so maybe use a straight table chart if you need a filter within the object.

[sunny_talwar]

I was thinking of flagging the last three rows with 1 and rest of the 2 as null and then on the properties tab going to select 'Omit Rows Where Field is Null' for the flag dimension. But I really don't know what the goal is

[swuehl]

Might be a good idea anyway..

[#6]

please give expression for Straight table

[sunny_talwar]

What is the logic? Unless we know why you want to show the last 3 it would be difficult to offer a solution

[#8]

i have 55 records in Field City but i have to show the records only 5 among that 55 in any table or straight table

[#9]

i have to show the data only few particular Cities(Only 5records)

[swuehl · Accepted solution]

Create a straight table chart with all your 5 fields as dimension and a single expression

=Only({<City = {Spain,Delhi,Hyd}>} City) // adapt the list of cities as needed

On presentation tab of chart properties, hide the expression column.

Is this what you want?