How do know the groups from your data? I didn't see any Transaction Type from your data
Yeah thats why im having trouble.
So i have transaction IDs and department codes.
I have made them into two groups.
Group A and Group B.
The Transaction types would be.
Does that make sense
Get Outlook for Android<https://aka.ms/ghei36>
I grouped them in the dataset. Department Code (group)
So I'm trying to figure out of total TxnID what % is just
A Transactions which involve Department 3,4,5
B Transaction which involve Deparment 11 - 82
AB Transaction which has a product from BOTH Group A (Any Department from 3,4,5) and Group B (Any Deparment from 11 - 82)
Once I have them sorted into a Transaction Type I should be able to use that to compare them against themselves and other types!
Thanks for your explanation. It is much easier for me to understand your requirement.
Please find my result below and I attached the workbook with 10.2 for your reference. Please let me know if you have question.