Are in desperate need of help. Hope some of you genuises can help me.
I have the following data;
PatientNo / Visit / Sex (female and male) / HomeTown (Aneby, Eksjo, Nassjo)
Each PatientNo have 1 or more Visits.
Shows the number om visits (Sum(Visit)) and visitors (TextCount(Distinct PatientNo)) per dimensions HomwTown or Sex in a straight table. So far everything i exactly as I want it to be.
Shows the visits and visitors per dimension PatientNo in an other straight table if the number om visits exceeds 3. Works great.
Now I want to show number of visits and visitors if the number per unik visitors exceeds 3. This too I want to show per HomeTown or Sex as 1 dimension. As 2 dimension I want PatientNo. Is it possible? How do I do this?