I have 'compute by' brand sorted and tried an advanced table calculation but it doesn't seem to be the right approach. The ranks should reset for each pane based on the patient ID right?
The ranks were originally all showing up as one. When I tried an advanced table calculation they changed but are not accurate. The brands should each generate their own rank based on when the "patient" started the medication.