calculating values in a matrix report

Hi,
I have a sales report that uses a Matrix to pivot the data, such that I can
see sales by month and year by customerID
I have Month and year across in columns and customerId on the left in rows.
In the report, how do I show the difference between two values - for
example, for a given customer, I want to compare January this year to Jan
last year and show the diffeence in Dollars or percent.
How can I calculate the difference?
Thanks in advance for your assistance
regards
HabibYou can add static rows to your matrix:
In Layout view, right-click the data, or detail, cell of the matrix, and
then click Add Column or Add Row.
Then populate it with whatever.
"HSalim[MVP]" <hsalim@.msn.com> wrote in message
news:ORG8NevjIHA.4244@.TK2MSFTNGP06.phx.gbl...
> Hi,
> I have a sales report that uses a Matrix to pivot the data, such that I
> can see sales by month and year by customerID
> I have Month and year across in columns and customerId on the left in
> rows.
> In the report, how do I show the difference between two values - for
> example, for a given customer, I want to compare January this year to Jan
> last year and show the diffeence in Dollars or percent.
> How can I calculate the difference?
> Thanks in advance for your assistance
> regards
> Habib
>|||I have a similar situation .
Where you able to do it
Thanks
"HSalim[MVP]" wrote:
> Hi,
> I have a sales report that uses a Matrix to pivot the data, such that I can
> see sales by month and year by customerID
> I have Month and year across in columns and customerId on the left in rows.
> In the report, how do I show the difference between two values - for
> example, for a given customer, I want to compare January this year to Jan
> last year and show the diffeence in Dollars or percent.
> How can I calculate the difference?
> Thanks in advance for your assistance
> regards
> Habib
>
>