Difference in % between two columns in a Crosstable

[Bernhard Fleischmann]

I have a cross table as the example below and need to add a column showing the difference of column B vs. column A in %.

The aggregation Difference % Year over Year is not working for me in this scenario.

 

 

 

Product

Sales Previous Year (B)

Sales Current Year (B)

Diff in %

 

 

 

 

AAA

150

120

 

 

 

BBB

200

250

 

 

 

 

 

 

 

Regards,

Bernhard

[Khushboo Rabadia]

(sum(Sales Current Year (B))-sum(Sales Previous Year (B)))/(sum(Sales Previous Year (B)))

Diff %

[Jshop Patel]

 

In Above Cross table, how do you calculate the difference between two column from one field 'YR' i.e for row1 : 266-233 = 33 so and on...