Forum Discussion
Distinc count by record values
Hi,
hope someone can help me with the following:
Based on the table below, I want to calculate how often a certain combination occurs per unique MO_Monsternummer value?
concerns the combinations based on column "Categorie coli":
- 1 and 2
- 1 and 4
- 3 and 2
- 3 and 4
The result i'm looking for is this:
regards
ICTURION
A trickier solution to your tricky question,
5 Replies
A trickier solution to your tricky question,
thank you. I didn't realize the solution was so tricky
Hi CNENFRNL,
Is it also possible to calculate the numbers per category in a separate measure? I also want to be able to calculate with the different results per category. For example by dividing the number of category "1 and 2" by the number of category "1 and 4". so 2/5 = 0.4
MO_Monsternummer Categorie coli 123 1 123 2 234 1 234 4 345 3 345 2 456 1 456 4 567 1 567 4 678 1 678 4 789 1 789 4 789 3 789 2 Hi SMPA01, her is the sample data in a table format. Thank you
