6 Replies Latest reply: Apr 9, 2014 12:38 PM by Jeremy Schmitt RSS

    Input Box Variable and Displaying Data

    Jeremy Schmitt

      I have an assortment of columns in a pivot table that are loaded in as one field and they have dates from 1/01/2003-1/01/2019, but it also contains a few names show below.

      Capture2.JPG.jpg

      I set up some start and end date variables based on the field that creates these columns because I want to display the last 6 and future 6 months. The issue I am having is it is limiting my columns to only the dates between my start and end date, But I want the ERC, Pool Life Totals, and IRR to display along with my desired months. I am not sure of a way to get the months I want, along with the named ones, to display being they are bother numberic and character.