I have a simple crosstab report with one measure, Sales Amount. It has 7 rows, one for each product, and 2 columns: one for 1997, one for 1998. I want to add a % increase column…
those are two workable solutions. however! the formula should be: (( Where (=1998) - Where (=1997))/( Where (=1997)))*100
sorry to nitpick. now,back to the merits of each solution.
the first method would be fine as long as you have only a variable or two, and don’t mind updating it 2 months from now for 1999 and 1998.
i have a preference for the second method. it makes it easier to include many variables and you can just use a prompted condition object for each query to select years to ocmpare. you will still have to do some manual labor to add the percentages. i am currently looking into reportscript and/or ole automation to alleviate that burden as well.
walter’s suggestion is excellent(as usual), particularly in light of your desire to drill down.
frank b. duncan
decision support specialist
national city corporation
Listserv Archives (BOB member since 2002-06-25)