Multiple values for one dimension

Fri, 20 Nov 2020 18:02:30 GMT

Hello,

I want to create an expression to check if a dimension has more than one value.

For example:

Customer ID Product ID

11 1

11 2

15 3

15 4

16 5

Customer 11 has 2 products.

I want an expression to check if one customer has 1 product or more than one.

Thanks!

Re: Multiple values for one dimension

settu_periasamy — Fri, 02 Oct 2015 02:49:07 GMT

Hi,

if your Dimension is Single(Customer ID only), you can try the normal expression in straight table, like

=if(Count([Product ID])>1,'More than One','One')

if you have more dimension, you need to try the aggregation like

=if(Aggr(Count([Product ID]),[Customer ID])>1,'More than One','One')