Skip to main content
Announcements
Marching toward a simplified navigation! READ ON
cancel
Showing results for 
Search instead for 
Did you mean: 
jessica_webb
Creator III
Creator III

Limit dimension based on expression outcome

Hi,


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

Dim1Dim2SUM({<GEN={'ALL'}>}NUM)=IF((SUM({<GEN={'ALL'}>}NUM))>9,AVG({<GEN={'ALL'}>}AP))
1ABC1-

1

DEF5-
2GHI2-
2DEF1865.2
3ABC2375.1
3GHI8-
3JKL1259.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

1 Solution

Accepted Solutions
avinashelite

Try like this

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



View solution in original post

4 Replies
avinashelite

Try like this

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



jessica_webb
Creator III
Creator III
Author

Perfect - thank you very much Avinash!

avinashelite

Your always welcome

Anonymous
Not applicable

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