The Spotfire Community is moving to TIBCOmmunity and this forum location has closed. During the transition, you can still search the old forums but posting has been disabled. We encourage you to pick up the discussion at the new Spotfire community on TIBCOmmunity.
Subtotals and Sorting of Cross Tables from Spotfire v3.3 - Tip of the Week

Tip of the Week

Subtotals and Sorting of Cross Tables from Spotfire v3.3

In TIBCO Spotfire version 3.2, there were some updates to Cross Tables, which allowed users to add subtotals for each level of a given hierarchy.  In TIBCO Spotfire version 3.3, more updates were released to enhance and extend this functionality. 

In 3.2 the subtotals were always applied to every parent level of a hierarchy. Now, starting in 3.3, you can specify which level of the Cross Table hierarchy should have subtotals applied. This is done in the Properties dialog for the Cross Table under the ‘Column subtotals’ section.

You can also now specify whether the subtotals should be displayed before or after the axis values.

In addition to this update, Spotfire now supports showing only the top or bottom N values in a specific Cross Table grouping. This is done in the Properties dialog for the Cross Table under the ‘Sorting’ section.
There is a checkbox labeled ‘Show only top/bottom’ and we can set that option and the specific number for both columns and rows in the Cross Table. There is also a checkbox to specify whether there should be an indication that some rows or columns are hidden.

For example, if our data has 20 rows of values for a specific grouping that are displayed by default in the Cross Table, and we set the option to only show the top 5, and also check the ‘Indicate hidden rows’ value, than only the top 5 will be shown and then a cell will be added with ‘ …’ in it representing that there is additional data which is currently hidden.

Specifying whether the rows or columns should be in ‘Ascending’ or ‘Descending’ order will determine if the top or bottom N values are displayed.

In addition, you can use the bookmark features to capture different states of the visualization properties to expose different options for the user via property controls. For example, you can  create bookmarks and then Action Controls which will toggle subtotals to be on top or bottom, as shown below:

The option for specifying  the number of  rows or columns to display does not take in expressions, so there is no way to use property controls to alter these values directly, but you can do it with a bit of scripting and property controls. The following script will take in two parameters, cTable which refers to the specific Cross Table and intTopNRows, which refers to a property for setting the number of rows to show.

from Spotfire.Dxp.Application.Visuals import CrossTablePlot
crossTable = cTable.As[CrossTablePlot]()
crossTable.ShowTopNRows = True
crossTable.TopNRowCount = intTopNRows





Walt Dickson said:

it is best think to follow the groups..

June 9, 2011 3:44 AM

EVE Isk said:

I have been keeping track of your site for a long time I read these articles, this is an interesting reading I will continue to pay attention to it more

Your article is one of the most classical style, when I read once, I have been deeply in love with them, you look forward to more perfect work.

December 19, 2011 10:17 PM

uggkensington said: | UGG Fox Fur Short Boots 5531 | UGG Kensington Boots 5678 | UGG Rainier Eskimo Boots 5189 | UGG Retro Cargo Boots 1895

December 27, 2011 7:57 PM

uggskensingtonsale said:

www.uggskensingtonsale.orgugg-adirondack-boots-ii-c-6.html | UGG Adirondack Boots II

www.uggskensingtonsale.orgugg-adirondack-tall-boots-c-11.html | UGG Adirondack Tall Boots

www.uggskensingtonsale.orgugg-amberlee-boots-c-34.html | UGG Amberlee Boots

www.uggskensingtonsale.orgugg-annabelle-boots-c-35.html |

December 28, 2011 3:42 AM

Martel said:

I am regular reader, how are you everybody? This piece of writing

posted at this web site is genuinely fastidious.

November 2, 2012 11:55 PM

John said:

Nice respond in return of this query with real arguments and telling everything regarding that.

November 3, 2012 1:15 AM

Ledesma said:

I constantly emailed this web site post page to all my friends, since

if like to read it then my friends will too.

November 3, 2012 2:55 AM

Thurman said:

Heya i'm for the first time here. I came across this board and I find It truly useful & it helped me out a lot. I hope to give something back and help others like you helped me.

November 3, 2012 4:16 AM

Ventura said:

Thanks for finally talking about >Subtotals and Sorting of Cross Tables from

Spotfire v3.3 - Tip of the Week <Liked it!

November 5, 2012 5:22 AM

Barbour said:

This is really interesting, You are a very skilled blogger.

I've joined your rss feed and look forward to seeking more of your excellent post. Also, I have shared your web site in my social networks!

November 5, 2012 5:25 AM

Folsom said:

Pretty section of content. I just stumbled upon your

site and in accession capital to assert that I get in fact enjoyed

account your blog posts. Any way I will be subscribing

to your augment and even I achievement you access consistently fast.

November 5, 2012 11:01 PM

Knudsen said:

I every time used to study paragraph in news papers but now as I am a user of net

so from now I am using net for posts, thanks to


March 22, 2013 8:41 AM

Fawcett said:

This design is steller! You certainly know how to keep a reader amused.

Between your wit and your videos, I was almost moved to start my own blog (well, almost.

..HaHa!) Fantastic job. I really loved what you had to say,

and more than that, how you presented it. Too cool!

April 15, 2013 6:03 PM

Switzer said:

Hey there! I just wanted to ask if you ever have any issues with hackers?

My last blog (wordpress) was hacked and I ended up losing many months of hard work due to no back up.

Do you have any solutions to stop hackers?

April 16, 2013 6:51 AM

Mcfadden said:

Usually I do not read post on blogs, but I wish to say that

this write-up very forced me to take a look at and do it!

Your writing taste has been amazed me. Thanks, quite nice article.

April 19, 2013 10:35 PM

Carrera said:

I was wondering if you ever thought of changing

the structure of your blog? Its very well written; I love what

youve got to say. But maybe you could a little more in the

way of content so people could connect with it better. Youve

got an awful lot of text for only having 1 or 2 images.

Maybe you could space it out better?

May 8, 2013 1:38 AM

Mayfield said:

Way cool! Some extremely valid points! I appreciate you writing this article and also

the rest of the site is extremely good.

June 5, 2013 2:41 AM

Clawson said:

Hi, after reading this awesome piece of writing i

am as well cheerful to share my familiarity here with friends.

June 7, 2013 12:46 PM

Cerda said:

Tarot voyance www tirage de tarot gratuit

July 7, 2013 2:28 AM

Barnard said:

Totalement gratuit au feminin astro

July 12, 2013 8:55 AM

Aranda said:

Sagittarius horoscope horoscope gratuit ascendant

July 12, 2013 12:22 PM

Mckenzie said:

Predictions gratuites tarot persan de madame indira

July 13, 2013 3:28 AM

Matheson said:

Formation en architecture format feuilles

July 14, 2013 11:07 AM

Bullock said:

Fauvel formation bergerac alternance conseil formation

July 14, 2013 1:31 PM

Pinkerton said:

Centre de formation informatique paris formater disque

dur en ntfs

July 14, 2013 1:38 PM

Beaudoin said:

Jeux de tarot gratuit tirage de cartes gratuit oracle

July 17, 2013 5:33 PM

Hildreth said:

Signe astrologique compatible horoscope cancer juillet

July 17, 2013 8:05 PM

Rodrigue said:

Horoscope balance 2012 gratuit prostitute astrologie chien

July 18, 2013 1:56 AM

Padgett said:

Liste des signes astrologiques pharmacy tirage de cartes

July 18, 2013 4:26 AM

Shields said:

13 signes astrologiques signe astrologique 21 mai

July 20, 2013 1:19 AM

Schramm said:

Horoscope amerindien medium gratuit par email

August 6, 2013 7:02 AM

Spears said:

Then a motorbike But you know without fudgingwhether your

job is adding to or subtracting from yourhappiness on an

overall basis. Therefore the European Union to pass

a helmet law for motorbikes. So, you should check whether it contains the Department of

Transportation DOT rating on helmets signifies that the helmet will

roll off of your head.

August 7, 2013 6:17 PM

Swearingen said:

Cartomancie divinatoire gratuite horoscopedujour

August 9, 2013 10:37 AM

Prince said:

Comptabilite des signes astrologique tirage carte


August 10, 2013 9:26 AM

Haines said:

Ton avenire selon le tarot divinatoire abraj maktoob daily horoscope

August 10, 2013 5:04 PM

Delarosa said:

It is used in many high-tech industries, including the sale of the division last

year to ***'s Sporting Goods for peanuts. Even if you are willing to get the hunters to misdirect him around. If the justices repeal the entire law, the new insurance market will never be a good thing though since it will also be displayed. While all this is going on, DPS still needs to damage the boss so make sure to tip them.

August 11, 2013 6:43 AM

Ibarra said:

Tirage de tarot gratuit amour horoscope scorpion femme

August 16, 2013 1:39 PM

Grice said:

Tarot horoscope gratuit denis lapierre cartomancie croisee

August 17, 2013 12:20 PM

*** said:

Horoscope amoureux gratuit 2011 horoscope oracle gratuit

August 19, 2013 4:02 AM

Doughty said:

Date signe cancer tarots gratuits en ligne denis lapierre

August 20, 2013 10:19 AM

Cassell said:

Horoscope poisson travail 2012 3 juin signe astrologique

August 21, 2013 12:43 AM

Schwartz said:

Sexe crimes photo ejac facial

August 21, 2013 2:29 PM

Crockett said:

Mon avenir selon denis lapierre aol astro

August 28, 2013 4:05 PM

Collado said:

What a information of un-ambiguity and preserveness of precious familiarity concerning unpredicted feelings.

September 3, 2013 2:05 PM

Rohr said:

Useful information. Fortunate me I discovered your website

unintentionally, and I'm stunned why this coincidence did not came about earlier!

I bookmarked it.

September 10, 2013 4:19 AM

Stout said:

It's actually a great and helpful piece of info. I am happy that you simply shared this helpful info with us.

Please stay us up to date like this. Thanks for sharing.

September 10, 2013 9:03 AM

Talbott said:

What's up to every single one, it's genuinely a nice for me to go to

see this web page, it includes priceless Information.

September 10, 2013 9:53 AM

Boatwright said:

Tirage des tarots gratuits signes astrologiques compatibilite

September 17, 2013 3:47 PM

Nagle said:

What's up everyone, it's my first go to see at this web page, and article is

truly fruitful in favor of me, keep up posting such articles or reviews.

September 18, 2013 11:44 AM

Pape said:

*** maroc bull put spread

September 18, 2013 10:19 PM

Cheney said:

Tarot oracle gratuit horoscope du jour gratuit elle

September 18, 2013 10:41 PM

Spowers said:

Youtube videos pornos films streaming x gratuit

September 19, 2013 4:56 AM

Morey said:

I visited several web sites except the audio quality for audio songs current at this web

site is in fact superb.

September 20, 2013 10:50 PM

Gillon said:

I am sure this piece of writing has touched all

the internet people, its really really nice post on building up new weblog.

September 21, 2013 10:45 PM

Kalman said:

Cul gratuit amateur amateur porn clip

September 22, 2013 6:26 PM

Creswick said:

logiciel statistique gratuit logiciel dessin graphique

September 22, 2013 11:06 PM

Phares said:

tarot euroresidentes amor eva suarez vidente

September 24, 2013 11:57 AM

Stapley said:

Hola! I've been following your website for a long

time now and finally got the bravery to go ahead

and give you a shout out from New Caney Texas!

Just wanted to tell you keep up the excellent work!

September 28, 2013 10:43 PM

Bolinger said:

I'm really impressed with your writing skills as well as with the layout on your weblog.

Is this a paid theme or did you modify it yourself?

Either way keep up the excellent quality writing, it's rare to see a great blog like

this one today.

September 29, 2013 4:28 AM

Garten said:

Wonderful site. A lot of helpful info here. I am sending it to

some pals ans additionally sharing in delicious.

And obviously, thanks in your sweat!

September 29, 2013 5:24 AM

Ruatoka said:

What's up to all, it's truly a good for me to go to see this site, it consists of helpful Information.

September 29, 2013 1:03 PM

Volz said:

Star porno us videos ejac interne

September 29, 2013 10:40 PM

de Largie said:

Scorpion horoscope du jour lion astrologie compatibilite

October 1, 2013 1:40 AM

Alder said:

tirada de tarot gratis online libros de tarot

October 1, 2013 6:56 AM

Joslyn said:

Hi, I do think this is an excellent blog.

I stumbledupon it ;) I'm going to return yet again since i have book-marked it.

Money and freedom is the greatest way to change, may you be rich

and continue to help others.

October 1, 2013 1:05 PM

O'Haran said:

Having read this I thought it was really enlightening. I appreciate you taking the time and

effort to put this short article together. I once again find myself personally spending a significant amount of time both reading and commenting.

But so what, it was still worthwhile!

October 1, 2013 2:12 PM

Borowski said:

Greetings! Very useful advice in this particular post!

It's the little changes which will make the

greatest changes. Thanks a lot for sharing!

October 1, 2013 3:35 PM

Bachman said:

Hey there just wanted to give you a quick heads up.

The words in your content seem to be running off the screen in Ie.

I'm not sure if this is a format issue or something to do with web browser compatibility but I

figured I'd post to let you know. The style and design look great though!

Hope you get the problem resolved soon. Thanks

October 2, 2013 6:27 PM

Waldman said:

Tatouage tribal signe astrologique caracteristiques signes astrologiques

October 2, 2013 10:43 PM

Moulden said:

Voyance par mail serieuse horoscope homme capricorne

October 3, 2013 4:55 PM

Bardolph said:

This is really interesting, You're a very skilled blogger.

I have joined your feed and look forward to seeking more of your fantastic post.

Also, I've shared your site in my social networks!

October 3, 2013 9:31 PM

Schmitt said:

Please let me know if you're looking for a article author for your blog.

You have some really great articles and I think I would be a good asset.

If you ever want to take some of the load off, I'd absolutely love to write some

articles for your blog in exchange for a link back

to mine. Please send me an e-mail if interested.


October 3, 2013 11:55 PM

Leija said:

Hi there, yeah this paragraph is really fastidious

and I have learned lot of things from it about

blogging. thanks.

October 4, 2013 4:15 AM

Macfarlan said:

Video x 100 gratuit marocaine sexe

October 5, 2013 2:29 PM

Pilkington said:

Thanks for one's marvelous posting! I certainly enjoyed reading it, you may be a great author.I will

make sure to bookmark your blog and definitely will come back very soon.

I want to encourage one to continue your great posts, have

a nice weekend!

October 6, 2013 12:10 AM

Shackleton said:

Why is it that your credit standing doesn't matter to payday advance lenders online

or at the storefront location e l f cosmetics coupons

printable if you've got a repossession of bankruptcy,

you'll be able to't really fix the issues but you'll be able

to start to spend on-time now.

October 8, 2013 3:05 AM

Murph said:

Hey There. I found your blog using msn. This is a very well written article.

I'll be sure to bookmark it and return to read more of your useful information.

Thanks for the post. I will certainly return.

October 9, 2013 1:11 PM

Lennon said:

Hi there, this weekend is fastidious in favor of me, since this time i am reading this wonderful informative paragraph here at my house.

October 11, 2013 12:19 AM

Culp said:

It's awesome in support of me to have a web site, which is valuable in favor of my experience.

thanks admin

October 11, 2013 1:25 AM

Tyson said:

Hi there, just wanted to say, I loved this post. It was practical.

Keep on posting!

October 13, 2013 12:39 AM

Walpole said:

el mejor vidente de espana si no tarot

October 27, 2013 1:21 PM

Leave a Comment



Other Spotfire Blogs

©Copyright 2000-2011 TIBCO Software Inc | Privacy Policy | Terms of Use I Blog I Contact Us I Content Center