How to delet Null rows in pivot table ?

[momofiore]

hey guys

i'm trying to delete a rows that doesn't contain anything in a pivot table but i cant find the solution. i dont use any dimension just expressions

here is attached picture. if somebody could help me thanks.

i can use instead of the pivot table a  straight table

youssefbelloum‌

[MK9885]

what are your expressions?

[momofiore]

for passengers   =Sum ([# Transported Passengers]) / Sum ([# Available Seats])

for client   =Sum ([# Transported Passengers])

you can put any expressions you want what the important for me is to delet the the empty row

@arvind654 thanks

[MK9885]

Do you have null values in any of your dimensions (([# Transported Passengers] or [# Available Seats]) ?

Without using Dimension or Calculated dimension how are you getting values as Passenger and Client?

Usually to remove nulls you can use len trim with if condition in back end or

use set analysis like below

Sum({<[# Transported Passengers] -={0}>}[# Transported Passengers] ) / Sum ([# Available Seats])

Sum({<[# Transported Passengers] -={0}>}[# Transported Passengers] )

Can you share a sample?

[vishsaggi]

Can you share this qvw file where you trying this?

[momofiore]

no no im no using any dimensions.

you cant just set any expressions you want. important for me is to have a table without the 2 empty cells.

you cant make for example passenger   -> 89/5*3   client   -> 69/78-9

you can use otherwise a straigte table or a table box .

[vishsaggi]

Can you share the app where you having this issue?

[momofiore]

here you can find my applcations

[vishsaggi · Accepted solution]

I believe you cannot suppress header row in pivot table. So try this in your straight table. Attached is the solution for straight table.