Counting clients according to their purchases

[ivanoski]

=COUNT({<{((SUM({<BRANDS={

'Michael Kors'

}, YEAR={$(vAñoMax)}>} NETSALES))/(SUM({<YEAR={$(vAñoMax)}>} NETSALES)))>0.5}>
}DISTINCT CUSTOMER_ID)

I am trying to count the number of clients whose total purchases of a brand are greater than 50% of their total purchases so far. but this formula I made does not work, I need help trying to figure this out. 

[sunny_talwar · Accepted solution]

May be try this

=Count(DISTINCT {<CUSTOMER_ID = {"=Sum({<BRANDS = {'Michael Kors'}, YEAR = {$(vAñoMax)}>} NETSALES)/Sum({<YEAR = {$(vAñoMax)}>} NETSALES) > 0.5"}>} CUSTOMER_ID)

[JGMDataAnalysis]

Try this...

COUNT(
      {<
        [CUSTOMER_ID] = {"=(SUM({<[BRANDS] = {'Michael Kors'}, [YEAR] = {$(vAñoMax)}>} [NETSALES]) / SUM({<[BRANDS] =, [YEAR] = {$(vAñoMax)}>} [NETSALES])) > 0.5"}
      >}
        DISTINCT [CUSTOMER_ID]
)

[ivanoski]

A thouthand thanks, another mistake i was doing is apparently qliksense didn´t like the way i was spacing things, i removed the spaces and it worked.

[ivanoski]

How do I show the NETSALES of the result of that formula? in other words, the net sales of the customers that resulted from that formula, just a total

[sunny_talwar · Accepted solution]

This

=Sum({<CUSTOMER_ID = {"=Sum({<BRANDS = {'Michael Kors'}, YEAR = {$(vAñoMax)}>} NETSALES)/Sum({<YEAR = {$(vAñoMax)}>} NETSALES) > 0.5"}>} NETSALES)

[JGMDataAnalysis]

SUM(
    {<
       [CUSTOMER_ID] = {"=(SUM({<[BRANDS] = {'Michael Kors'}, [YEAR] = {$(vAñoMax)}>} [NETSALES]) / SUM({<[BRANDS] =, [YEAR] = {$(vAñoMax)}>} [NETSALES])) > 0.5"}
    >}
      [NETSALES]
)

[ivanoski]

Genius!