How do I create a Fast Type Change icon that works ?

[#1]

Hi All,

I have a Container object which holds a pivot table and a chart. The pivot table is sorted on Dimension 1. However, I want to create a different pivot table which sorts the data on Dimension 2. Rather than create another object within the container, I want to create a Fast Type Change icon to toggle between the two pivot tables.

What are the steps I need to follow to make this work ?

Thanks

MV

[#2]

That sounds a good solution DataNibbler except I wouldn't know where to start.
MV

[#3]

I want to retain the container with just two objects if possible.

[#4]

Thanks Michiel but the requirement is for a pivot table, not a straight table. I know that the sort functionality for a pivot table is rather limited which is why I'm trying to find a simple means of toggling between two similar pivot tables (except for how they are sorted). Your example applications showed straight tables which can be sorted interactively. Pivot tables can't.

[#5]

Sounds good ! Except my QV knowledge isn't that good. A prize for the first person to give me the full instructions as to how to do this
MV

[morganaaron · Accepted solution]

Hi Maureen,

The conditional show suggested by DataNibbler is a good option if you're not using a container - the problem with this is it relies on you placing both objects in the same place for it to look seamless - with a container it wouldn't "replace" the other object as much as just hiding one and showing the other.

I've attached an app here that shows what I mean- the text box on the right flips between 0 and 1 in a variable that is used to show/hide the same pivot table simply with a different order for the dimensions.

[#7]

Oh I see ! You mean an example of using Text objects as buttons. OK, I'll see how I get on. Thanks

[#8]

Many thanks Aaron. That's worked fine. Much appreciated.

MV

[#9]

hi,

just click on pivot table then go to general tab on the right you'll find allowed types just checked the type which you want