Limit dimension based on expression outcome

[jessica_webb]

Hi,

I have a fairly simple straight table with a couple of dimension and a few expressions:

Dim1	Dim2	SUM({<GEN={'ALL'}>}NUM)	=IF((SUM({<GEN={'ALL'}>}NUM))>9,AVG({<GEN={'ALL'}>}AP))
1	ABC	1	-
1	DEF	5	-
2	GHI	2	-
2	DEF	18	65.2
3	ABC	23	75.1
3	GHI	8	-
3	JKL	12	59.4

All I want is to not show the rows where the last column is null!

I've tried using a calculated dimension as follows:

=aggr(if(SUM({<GEN={'ALL'}>}NUM)>9, Dim2),Dim2)

But this isn't working for me!

Anyone have any ideas?

Thanks,
Jess

[avinashelite · Accepted solution]

Try like this

aggr(if(SUM({<GEN={'ALL'}>}NUM)>9, Dim2),Dim1,Dim2)

[jessica_webb]

Perfect - thank you very much Avinash!

[avinashelite]

Your always welcome

[Anonymous]

Hi,

is this also possible via conditional show for the dimension?

I want to use a text field to switch between viewing all_orders and only open_orders

(sum(TotalQuantity) - ProcessedQuantity) > 0 = open_orders

thanks,

lucas