Skip to Main Content
Status Future consideration
Categories Reports
Created by Guest
Created on Oct 21, 2020

Display sequential quarters on pivot table

I am creating a custom roadmap which lists all of our initiatives we plan to deliver in 2021. Some are being delivered in Q1, Q2, and Q4. Because there are no initiatives being delivered in Q3 - the column for Q3 doesn't appear. This causes confusion to the viewer - when I look at the report, I expect the report to be showing sequential quarters for a given timeframe and it forces them to really read the column headers to understand what they're looking at. To work around this, I have created fake initiatives and plotted them as being complete in Q3 so that the Q3 column appears. This is then causing me issues when I export my presentation to PDF.

  • Attach files