Identify store v2

[#1]

Hi all,

How can I obtain a straight table with the number of duplicated stores ?

Thank for your help.

Judikael.

[swuehl]

Duplicated in what context? Or how do you get e.g. the number 7 for store A01?

[#3]

When I select store A00, I see nov, oct, sept, aout, juil and juin so 6 for A00.

I want to obtain the list of duplicated store by year or by month if there are duplicated by month in the straight table .

[MK_QSL · Accepted solution]

Try Straight table..

Dimension = Store

Expression = COUNT(Distinct Month)

or

COUNT(DISTINCT {<NbrStore = {'>0'}>} Month)

Hope this helps..

[#5]

Hi Manish,

It works well.

Thanks.