Good afternoon.
I have got two separate worksheets from April 2019 to Sep 2019 and April 2020 to Sep 2020 for these 4 drugs: Rivaroxaban, Dapagliflozin, Empagliflozin, Ticagrelor. The system has the latest prescribing data until Sep 2020.
This time it's a new indication for an existing product so we need to see the monthly increase in spend i.e. April 2019 to Sep 2019 vs April 2020 to Sep 2020 but can be done as one increase for the whole group rather than individually like the list above. I tried to do a pivot table but my Excel knowledge is very basic. I don't know how to present the data of these 4 drugs comparing their prescribing e.g Ticagrelor April 19 vs April 20. Please show me the steps so I can follow and improve. Thank you in advance.
Jignesh.
Bookmarks