straight table

[#1]

Hi Team

I have a straight table which is having 25 rows

can we delete certain rows in the straight table, how can we do

regards

Pnreddy

[lukaspuschner]

can you attatch the file and explain which rows you want to delte?

[MK_QSL]

You can load certain rows...

consider that you wants to load only three customer out of five as C1, C2, C3, C4, C5

Use Calculated Dimension

If(Match(Customer,'C1,'C2,'C3),Customer)

Tick Suppress When Value is null

Expression May be something like SUM(Sales)

This will load only data for customer C1, C2 and C3.

[its_anandrjs]

Use calculated dimension for that or if have a sample data so provide that.

[#5]

in those customers i want to delete only c3 how can we do

[its_anandrjs]

Updated now check

Write like

If( Not Match(customers,'c3'),customers) in the dimension

Or

If(customer <> 'C3', customer)

[SunilChauhan]

if some values are null then

go to presentation tab -> select field and check Omit when null

[MK_QSL]

IF(Customer <> 'C3', Customer)

or

If(NOT Match(Customer,'C3),Customer)

TIck Suppress When Value is NULL

[jonathandienst]

Hi

Calculated dimension:

= If(Customer <> 'C3', Customer)

OR

=Aggr(If(Customer <> 'C3', Customer), Customer)

And check suppress nulls for that dimension.

HTH

Jonathan

[#10]

i want to delete bello a4  row what to do