Hi,
I have a report which is showing monthly sales figures on a matrix. the Rows
are grouped by year and product and the Columns grouped by month. What i
would like to achieve now is to add a column between each month column to
show the % increase between the months.
so that the report looks something like:
Year JAN % diff FEB %diff
MAR ......
2004
Product A 10 100% 5 0%
5 ......
Product B .....
...
2003....
...
regards,You could put a rectangle which has two textboxs in the data cell. One
textbox is for sum of sales and another for percentage of increase. In
column header, do same things to show different title.
Regards,
Henry
"Kazar" <kazar@.kazar.kaz> wrote in message
news:uO%23kdK0lEHA.2880@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I have a report which is showing monthly sales figures on a matrix. the
> Rows
> are grouped by year and product and the Columns grouped by month. What i
> would like to achieve now is to add a column between each month column to
> show the % increase between the months.
> so that the report looks something like:
> Year JAN % diff FEB %diff
> MAR ......
> 2004
> Product A 10 100% 5 0%
> 5 ......
> Product B .....
> ...
> 2003....
> ...
>
> regards,
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment