% Change Calculation in chart

[#1]

Hi,

I have a chart in which Quarter is a dimention,Count is an inputfield and Cost,Paid are expressions.I need to calculate % change for next quarter incomparision with the previous one.Can someone please let me know how to do this % change calculation and display it in the same cell just below the cell value?

Quarter	Count	Cost	Paid
2010-Q1	20	100	60
2010-Q2	30 (50%)	150 (50%)	75 (25%)
2010-Q3	45 (50%)	180 (20%)	125 (66.6%)

Ex :calculation for % change for count in 2010-Q2 is [(30-20)/20]*100=50%

Thanks,Pooja

[swuehl · Accepted solution]

For Cost and Paid, I think it could look like

= sum(Value) & chr(10) & num(sum(Value)/above(sum(Value))-1,'#.0 %')

(and check the wrap cell text in presentation tab).

You could also use similar for the inputfield (remember to use one of the inputfield aggregation functions like inputsum or inputavg), but it looks like this will disable the actual input functionality (while just using e.g.  inputsum(Value) should work).

[#3]

Thanks..It worked in the expression value cells.But the Expression total comes back as 0.Is there a way to fix it.

[swuehl]

I would assume yes, I just tried in a pivot and the horizontal line total seems to be ok. What do you see, and what results do you expect?

[#5]

there was some issue with the expression so it couldnot calulate the total using the Partial sum of pivot table.Thanks.