Monday, March 12, 2012

Matrix Counting and Totals

I have a report in matrix format. The weeks are across the top and the
calculated field is in the rows. I need to be able to count accounts that
have ordered for that week which I was able to do. I also need to count if
this is the first time the customer has ordered "ever" and if they are
re-ordering. A re-order is considered if they have ordered twice. Does
anyone have any suggestions on the best way to do this?Are you getting your data from SQL Server? If possible, I'd do the counting
in the query itself, not the report. It's a lot easier to do counts in SQL
than in a matrix.
If you do want to count in your report, you could use the InScope function,
and check if you are inscope for the account group.
A bit of pseudocode to show what I'm thinking
=IIF(InScope("AccountGroup"), runningvalue(fields!Order.Value), 0)
(Please verify syntax...)
Kaisa M. Lindahl Lervik
"Debbie Nelson" <Debbie Nelson@.discussions.microsoft.com> wrote in message
news:0CC9D925-B21D-4E0D-A59C-C1B9821F59FC@.microsoft.com...
>I have a report in matrix format. The weeks are across the top and the
> calculated field is in the rows. I need to be able to count accounts that
> have ordered for that week which I was able to do. I also need to count
> if
> this is the first time the customer has ordered "ever" and if they are
> re-ordering. A re-order is considered if they have ordered twice. Does
> anyone have any suggestions on the best way to do this?

No comments:

Post a Comment