4 Replies Latest reply on Mar 8, 2013 6:45 AM by fahim m

Difference Across Table (other than First, Last, Previous, Next)

I need to calculate difference across any year. The quick table calculation has FIRST, LAST, PREVIOUS, and NEXT. Currently I have done it with the FIRST year.

Is there a way to choose the year based on which to calculate the difference. I tried to create a parameter and it did not work. I have attached the workbook.

Thanks much

Fahim.

• 1. Re: Difference Across Table (other than First, Last, Previous, Next)

Hi Fahim,

I think it is possible, but you have to create a manual calculation to do it.

I've amended your work book and attached.

I've created "Value at Chosen Year" = to summarize what the value is to compare to since it cannot use a default of first, last, previous or next.

Then I've created a calc of "Diff" and used that to map the graph, making sure it is calculated over years.

Does this help?

Dana

• 2. Re: Difference Across Table (other than First, Last, Previous, Next)

Dana,

Thanks so much, the logic you have used is absolutely correct.

However, the Diff Along Table (Across) values should be positive when compared to 1990 (for Alabama in 1991 should be 4.3 instead of -4.3).

The co2 emissions for value of chosen year must be subtracted from CO2 emissions of all years. Currently the calculation is opposite.

I tried to correct the calculation but it did not work. Please, can you help.

Thanks much

Fahim.

1 of 1 people found this helpful
• 3. Re: Difference Across Table (other than First, Last, Previous, Next)

Hi Fahim,

No Problem - The line graph is mapped based on the "Diff" field.

I put it in as [Value at Chosen Year]-sum([Carbon-di-Oxide Emissions(MMT)])

Just change it to sum([Carbon-di-Oxide Emissions(MMT)])-[Value at Chosen Year].

See attached

Good luck,

Dana

1 of 1 people found this helpful
• 4. Re: Difference Across Table (other than First, Last, Previous, Next)

Dana,

I figured it out. Thanks so much.

It was a very smart solution.