Ignore filters

[#1]

Hi all, i have this situation

1 colum expresion:

DesNivArt1

2 colum expresion:

Count( distinct codcli)

3 colum expresion:

(Count( distinct codcli)/

COUNT({1} DISTINCT ALL codcli))*100

anoVtaCab is a year like 2016 - 2015 - 2014...

DesNivArt1 is the company that provide me the items I sale... in 2 i know how many clients buy an item of the company... in the 3 colum i know the percent of customers that purchase an item of the company, compare to the total customers i have (all customers)... now i want to know the percent of clients compare to the customers who bought me in the selected year. For example

     total clients of "DesNivArt=01"

-----------------------------------------------------  X 100

total clients i sale in a year selected

[sunny_talwar]

May be this:

Count({<Year>}DISTINCT codcli)/Count(DISTINCT codcli) * 100

or

Count({1}DISTINCT codcli)/Count(DISTINCT codcli) * 100

[#3]

The problem is that those expresions consider "DesNivArt1", i want my expresion not to consider the dimension "desnivart"... so if i selected year = 2016 total customers should be 100 and no only 50 (the ones that buy items from a specific DesNivArt1)

[sunny_talwar · Accepted solution]

Not sure where you came up with 100 and 50, but may be this to ignore dimension

Count(DISTINCT TOTAL codcli)

[#5]

Thanks, that works