deviation %

[#1]

I use in my chart pivot to accomulate value this expression

RangeSum(Above(TOTAL SUM([field]),0,NoOfRows(TOTAL)))

it'ok and totalize and accomulate for year the value in this method

                   year 2010          year 2011               %

gen               100                              50                              -50

feb               200                              150           -33,33

mar      350                              300                             -16,66

apr               400                              400                              0

How determinate % espression??

Thanks

[swuehl]

I assume you are using two dimensions in your pivot table, month and year, and 1 expression, right?

This makes it a bit hard to determine % and keep the requested layout.

You can potentially use the partial sum column (activate in presentation tab of chart properties), and select the approproiate expression by a conditional using SecondaryDimensionality() to retrieve the information if the expression evaluated within a details or the partial sum cell.

But I think it's easier here to use a straight table chart, with 1 dimension month and three expression.

Two expressions to calculate your aggregated sums (1 for 2010, 1 for 2011):

=RangeSum(Above(TOTAL SUM({<Year={2010}>} Value),0,NoOfRows(TOTAL)))

=RangeSum(Above(TOTAL SUM({<Year={2011}>} Value),0,NoOfRows(TOTAL)))

and 1 expression to calculate the deviation in percent:

=column(2)/column(1) -1

See also attached.