Nested Set Analysis

[Sameer9585]

Hi,

I have a data as the file below in it sheet 3 now I need have the output as Sheet 4.

I need the output as distinct data and formula for KPI of count of distinct bills.

Thanking you in advance,

[JordyWegman]

Hi Sameer,

Why are 2,3,4,6,7 and 9 not included? Or do you also want them?

Jordy

Climber

[Sameer9585]

Because the Bills are repeated I don't want the repeated one's.
I tried this it works fine
Count(DISTINCT{<Bill={"=Count({Product=}Product) = 1"}>}Bill)
but the problem is I need to create a dimension for table for Bill in the same way

[JordyWegman]

Maybe it's me, but what is the definition of a repeat because I can't really see it.

Jordy

Climber

[Sameer9585]

I was saying that for suppose if you look at bill 2 there are about 3 products in such cases I don't want that bill numbers but for bill 1 there is only one product so I need it the table in that way.

[JordyWegman]

Hi,

So you want a dimension with only the bills that have a count of 1? You can make a indicator in the script that tells you if the bill count is just one. Do you know how to do that?

Jordy

Climber

[Sameer9585]

Yes, exactly,I know how to do indicator in the script that tells you if the bill count is just one

[JordyWegman]

Great, then you can use this formula:

Count({$< _indBilLCountIsOne = {1}>}Bill)

Jordy

Climber 

[Sameer9585]

I just want the bill not the count in the chart.

[JordyWegman]

You can then, in your dimension, use this if statement: 

If(Only(_indBilLCountIsOne)=1,Bill,null())

 Jordy

Climber