I have a query that spits out totals for a given month. My column headings in the query are the periods.
201804 201805 201806 201808
$556.66 $6689.00 $667 $833
I want my query to include 201807 even if it does not have a dollar amount.
This is the SQL line for the period column header: PIVOT [dbo_RX Reporting].Period
I have tried PIVOT Nz([dbo_RX Reporting].Period) but that did not work. Is there a way to do this?