Percentage value calculates only partly

[Peony]

Hi all. 

I faces with an issue in set analysis calculation for percentage for column % CIDs. 
For some reason I have calculated result only for Type P transactions. And I received nothing for Type W.  

To calculate I use this formula:

Count(Distinct CID)
/
Sum(Aggr(Count(Distinct CID), Market))

How to get result also for Type W?

[stevejoyce · Accepted solution]

You denomiator Aggr(Count(Distinct CID), Market) is only going to return 1 row for each Market, hence why P has a denominator but not W.

What do you want your denominator to be? Are you trying to sum all  types for each market?  So Barcelona is denominator of 205 and German is 57?

If so, that calculation would be like this:

Count(Distinct CID)
/
Count(Total <Market> Distinct CID)

[Peony]

Yes! Your suggestion is exactly what I need.  Thank you much for help!