Currently using Excel 2016/PowerPivot and using some Calculated Columns to create some “bands” for time based on two disconnected tables. It works, but I want all the bands displayed, even band does not have any values for them (should show “0” for them, if none fit criteria).
What I am getting is just the bands that have values in them.
See attached spreadsheet. “Desired Pivot” is what I am looking for, “Actual Pivot” is what I have. Data is in two worksheets – Data and Legend..