how can i creat a cross table
Just select the data and render the rows as you need them like in this example: https://docs.tibco.com/pub/spotfire/6.5.2/doc/html/cross/cross_what_is_a_cross_table.htm
If you are using an SQL-Database to read the data from you would need two or more SQL-statements to read the data for the original table and the cross table.
Answers
Just select the data and render the rows as you need them like in this example:
https://docs.tibco.com/pub/spotfire/6.5.2/doc/html/cross/cross_what_is_a_cross_table.htm
If you are using an SQL-Database to read the data from you would need two or more SQL-statements to read the data for the original table and the cross table.