I have a question for sorting a set of data by using pivot table and calculations: In patients that were switched to med B, what percent of the 2nd med B dose (total dose in month following the 1st dose) was the same as the 1st med B doese? Higher than the 1st dose? Lower than the first dose (but not a zero dose)? No dose at all(a zero dose)? (calculate for patients switched in Sep only, Oct only, and Sep and Oct together, assume Med B dose is for 1 month only)
Solved by Z. A. in 14 mins