topic Re: Ignore filters in App Development

Ignore filters

Tue, 13 Dec 2016 15:22:07 GMT

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

Re: Ignore filters

sunny_talwar — Tue, 13 Dec 2016 15:27:18 GMT

May be this:

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

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

Re: Ignore filters

Tue, 13 Dec 2016 16:35:24 GMT

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)

Re: Ignore filters

sunny_talwar — Tue, 13 Dec 2016 16:39:11 GMT

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

Count(DISTINCT TOTAL codcli)

Re: Ignore filters

Tue, 13 Dec 2016 18:14:42 GMT

Thanks, that works