13 Replies Latest reply: Feb 15, 2010 5:01 PM by John Lewis RSS

    Additional expressions at the end of a chart pivot table

      I'm wondering if something like this is possible. I have a chart set up as a pivot table with 2 dimensions: Item Number and Period Number. I have 1 expression that is Usage History. I have the pivot table set up with the Period as the column label so it looks something like this:

      Usage

      Item Period Jan Feb Mar Apr Jun...

      ABCDE 10 10 15 20 25...

      ZYXWV 5 7 8 10 12...

      Would it be possible to add another expression to the end of the chart is not part of the column label? For example, if I wanted to add Current Value to the end so it would look like this:

      Usage

      Item Period Jan Feb Mar Apr Jun... Curr Value

      ABCDE 10 10 15 20 25... 40

      ZYXWV 5 7 8 10 12... 25

       

      is this possbile?

      Thanks.