How to classify by multiple criteria in Tibco Spotfire?

Question

Database

There is a DB with transactions. For each transaction, there is a description in separate columns - date, amount, purpose, etc. (50 columns in total). One of the characteristics is the number of the contract under which the transaction is taking place. Each contract belongs to a certain class (this is not in the database), for example, 1.1, 1.2, 2.1, 2.2, etc. What you need is to write a query in tibco to classify contracts according to several characteristics and sum up the transactions for each class. That is, the output should be a table - 1.1 - XXX rubles, 1.2 - UUU rubles, 2.1 - NNN rubles. etc.