Alexander Baverstock Posted December 21, 2020 Share Posted December 21, 2020 Hi team, this should be a quick one. I want to do a basic rank cross table. A calculated column should show values 1 to 7 (rank) for values in column 2. Gen being number 1 etc. Everytime I add rank([Column2]) it asks to aggregate the formula. How should I do this This is very easy to show values by rank in excel. Read the link below. https://docs.tibco.com/pub/spotfire_server/latest/doc/html/en-US/TIB_sfi... Link to comment Share on other sites More sharing options...
Fabian Duerr Posted December 21, 2020 Share Posted December 21, 2020 As a calculated column use something like: DenseRank(Sum([Value]) over [Name],"desc")Or in a cross table put [Name] on your Y Axis andRank(Sum([Value]),"desc") on your X Axis Link to comment Share on other sites More sharing options...
Alexander Baverstock Posted December 22, 2020 Author Share Posted December 22, 2020 Great Cheers!! Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now