Hey guys,
I don't know if there is a better way to do this (since I havent really tried to do this before now), but I do know a workaround. You can use a union query to add the calculation to the result set. Probably not the best way if you need to add one hundred calculations, but definitely OK for one.
You create a query that uses a unioned tabular set. In one of the tabular models, have the query that returns the entire record set to include in the crosstab. In the other tabular model, apply filters to restrict the data that you want to calculate (ie account in ('a','c')) then dummy the value of the field in the rows to contain your text description.
Of course, the only catch is that to union the data you need to have the same data types in each of the fields you are unioning, so you might have to force your rows column to be a varchar column if it isnt already to be able to include your own label.
Ive created a report like this in the 'Go Sales and Retailers' package (see attached)
J
