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.
It looks like you're new here. If you want to get involved, click one of these buttons!
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.