Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Not sure where you came up with 100 and 50, but may be this to ignore dimension
Count(DISTINCT TOTAL codcli)
May be this:
Count({<Year>}DISTINCT codcli)/Count(DISTINCT codcli) * 100
or
Count({1}DISTINCT codcli)/Count(DISTINCT codcli) * 100
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)
Not sure where you came up with 100 and 50, but may be this to ignore dimension
Count(DISTINCT TOTAL codcli)
Thanks, that works