fix the selection

[#1]

AOA grus

i have table as follow

with three dimension

complaint_no	category	current staus	days
abc	networking	in progress	10
cde	networking	pending	5
efg	networking	pending	2
hij	networking	Resolve	2

i want to show another table only showing pending complaints

complaint_no	category	current staus	Reason	days
cde	networking	pending	Short of Inventory	5
efg	networking	pending	short of man power	2

so how to fix the 2nd table to only show pending complaint so if clear all field its stick to only pending...

[alexandros17 · Accepted solution]

Set in the dimension:

if(current_status='Pending, Current_status, null())

and check "exclude null values"

Hope it helps

[neetu_singh]

Hi,

In Dimension Tab,

Click on "Add Calculated Dimension" Button and write the below mention expression as:

= If(current status = 'pending',current status)

Check the check box for "Suppress Null Value".

Regards

Neetu