TABULUS®, The Table Oriented Spreadsheet

TABULUS® 2010 - Simply put, TABULUS is a better spreadsheet!

TABULUS® 2010 FREE Trial
home recent topics recent posts search faq

TABULUS® Forums
Messages in this topic - RSS

Home » Support & Discussion » How can I pivot the data in the worksheet?

|
9/4/2009 4:47:51 AM

rado
rado
Posts: 47 		One of the unique features of our product is our worksheet. Unlike other similar modeling programs it is not restricted to a simple model viewer/editor. You can visualize many tables simultaneously and to order them in very complex manner if necessary. You also can easily mimic pivoting similar to other applications. For us it is easier scenario. We will provide in the future simplified mode of our worksheet which will restrict it to the one table and the pivoting will be easier. How you can do it with our current features.

Let’s say we have a simple model with one table with two categories inserted. Each of categories has two items.
Drag table to column header of the worksheet. In drop dialog select “All items” group for each category.



Now you are ready to pivoting – simply drag “All items” group of desired category and drop it as header template in rows/columns.



And the result is:


edited by rado on 3/12/2010

--
Radoslav Nemchev
CTO, Diehl Technology LLC

Attachments:
DragForPivoting.jpg


DropForPivoting.jpg


PivotingResult.jpg
permalink
4/20/2010 9:14:21 AM

rado
rado
Posts: 47 		We have added a new feature in TABULUS 2010 SP1 which makes moving of category items from columns to rows very easy. Simply drag an item header from columns for example and drop it in row headers area.
A dialog appears.



Answer "Yes" and the result is:


edited by rado on 4/20/2010

--
Radoslav Nemchev
CTO, Diehl Technology LLC

Attachments:
Image2[1].jpg


image1[1][2][3].jpg
permalink
pages: 1
|

Home » Support & Discussion » How can I pivot the data in the worksheet?