I created a simple crosstab in Discoverer that Sums all costs for two years and would like to find out the difference between the years. Is there a Discoverer formula or process that can handle that without having to export to Excel and do the anaylsis?
Cost Center Year 1 Year 2 Difference between Year 1 and Year 2
101 $500 $200 $300
102 $200 $50 $150
No, this is not easy to do in a crosstab report because you will need an extra row to show the difference value. One option is to create a view at the database level which uses an UNION ALL to create the additional different row.