3 Replies Latest reply on Mar 24, 2016 3:33 AM by John Sobczak

    Date Trunc Hierarchy Order - Continuous Line Issue

    John Sobczak

      In the attached 9.2 workbook using sample superstore sales data, I have an issue with my chart.  I am using months before years on columns shelf in my chart so that I can see the trend or pattern for each of the months across multiple years (first tab).  The problem is that when I have only one year as filtered on 2nd tab, the line changes to dots which I understand because there are no other years to connect trend line.  However is there a clever way I can switch the order back to years/month on columns shelf by parameter or otherwise when I only have one year in the data so the line will connect from Jan-Dec?