1 Reply Latest reply: Oct 19, 2011 12:21 AM by Kiran Rokkam RSS

    format expression in pivot table based off qualifier field

    Paula Powell

      I have a pivot table that I have created where I want to format the data in the pivot based off the values contained in a qualifier field.

       

      For example:

      pivot.bmp

      where form = 'late_loads%' the result for the attribute field eg. Jan-2009 should be a %, for everything else the current format is acceptable.

       

      Thanks