All except "Script Number" and "Month-Year Dispensed" are calculated values through expressions. I need to create a bar chart with average (TRx Traffic) on the Y- Axis and Month-Year on the X-Axis. Can this be done and if so, how?
ended up doing a separate SQL SELECT Distinct load and ordering by [Retail Pharmacy], [Branch] and [Date Dispensed]. This should work, i will check the results.