I have a query that spits out totals for a given month. My column heading in the query are the periods.
Ex.
201804 201805 201806 201808
$3333 $541180 $66725 $8339
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?