Calculating counts/totals from two data sets

beachbumm

I am trying to calculate by using the Total.sum and Total.count functions using columns from two different data sets.

How do you accomplish this? I tried joining the data sets, but they are really unrelated types of data.

Can you use expressions to do this?

Any examples would be greatly appreciated.

mwilliams

Hi beachbumm,

I'm guessing this issue has been solved already, but in case it hasn't or someone else has the same question.

Depending on your report setup, you could probably total each column and save the values to persistentGlobalVariables and add them in a dynamic text box where you're wanting to display the data.