list box data

[#1]

Hi

I have a data set in a table that is created and consists of around 30k unique entries.

However in my actual data set only about 10% of these have a value attached, ie you could think of this as being all customers ever set up but within the period only 10% have completed a transaction.

In my list box I only want only the records that have a transaction to be shown so as to reduce the “clutter”.

The formula below appears to work as a much reduced list of records is brought through into the list box.

However the issue i have is that when one is selected the rest disappear completely out of the list box unlike with the standard list box where they are greyed out but stay in the box.

how can i edit my formula/settings so that the other options stay in the box and appear greyed out as per the standard formats of a list box?

=

Aggr(If(

(

fabs(ROUND(Sum(COST)))+fabs(round(sum(revenue)))

) <>0, [Driver Type]),[Driver Type]

)

[salto]

Hi Jono,

I am fraid I do not understand completely your question... If you only want the customers that have completed a transaction, I would left join the transactions data with the customers. The resultant table of the left join would only have the customers with transactions.

Hope this helps!

[Michiel_QV_Fan]

I agree with Salto.

However, you could also create a straight table with the customer as dimension and the transaction revenue as expression.

suppress zero values on the dimension and add a set analysis in the expression to show all values greater than 0.

Not a really nice solution, more a work around.

[bbi_mba_76]

Hi,

if I understand well you have to add a set analysis to ignore the selection.

So sum({1} ... if you want to ignore all selections, whereas you have to ignore only Field1

sum({<Field1=>} ...