4 Replies Latest reply: Apr 23, 2015 9:57 AM by Sunny Talwar RSS

    How to add a stand-alone row for a dimension in a pivot table?

      Hi,

       

      Does anyone know if it's possible, and if so, how to add a "stand-alone" row for a dimension in a pivot table?

       

      I want the pivot table to display data in a similar manner as below (with "stand-alone" rows I mean the rows 2, 3 and 8):

       

      YearQuarterMonthDayExpression
      2015255
      2015Q112
      2015Q1Jan18
      2015Q1Jan27
      2015Q1Feb19
      2015Q1Mar15
      2015Q245
      2015Q2Apr15
      2015Q2Apr25
      2015Q2Apr38

       

      The value 255 and the value 12 and 45 uses two other different expression than the rest in that column. Is this possible?

       

      Thanks!

      /Frida