Hide the blank data

[Anonymous]

Employee                Pending on who                           Id

Jane                         -                                                A1

Alex                         Raj                                            A2

Rachel                     Amir                                           B1

Mia                          -                                                C1

Mia                          Lisa                                           C2

What formula should i use,I want to show If employee has pending on who only and show the its id.

The result should be:

Employee                Pending on who                           Id

Alex                         Raj                                            A2

Rachel                     Amir                                           B1

Mia                          Lisa                                           C2

TQ

[Gysbert_Wassenaar · Accepted solution]

Create a straight table with Employee and Pending on who as dimensions and only({<[Pending on who] = {'*'}>}Id) as expression. If the blank fields are not really blanks but string values '-' then use only({<[Pending on who] -= {'-'}>}Id) as expression.

[maxgro]

maybe with a calculated dimension in a straight table chart

=if(len(trim([Pending on who]))>0, Employee)

and [Pending on who] and Id as expression