Dynamic columns of matrix

I have a matrix, I would like to have a subtotal and total that only
performs the action if the dynamic collumn has a particular value.
I have dynamic column A and B. I only want the subtotal for A not B.
BruceOn Mar 6, 12:31 pm, "Bruce L-C [MVP]" <bruc...@.newsgroup.nospam>
wrote:
> I have a matrix, I would like to have a subtotal and total that only
> performs the action if the dynamic collumn has a particular value.
> I have dynamic column A and B. I only want the subtotal for A not B.
> Bruce
I would suggest using a loop or cursor in the stored procedure or
report query sourcing the report to determine the subtotals and total.
Then in the report use a conditional expression to check for a
particular column value and if it is not the one that needs the
subtotal and total, substitute an empty value for the subtotal and
total. Hope this is helpful.
Regards,
Enrique Martinez
Sr. SQL Server Developer