TM1 Forum

Hi All,

Has anyone tried with active forms to sort the data?

By this I mean grouping all apples together, then oranges etc..

like this

apple
apple
apple
oranges
oranges
oranges

Should i be looking to a VBA solution that once the active form has updated, i then go and sort the result of the active form?

These active forms are tricky little suckers as well

Any other ideas suggestions?

vaneagle

Hello

I'm curious to see why you have multiple times the same element. Normally active forms are used to represent elements out of a dimension, which are unique by default.

Anyway, here's an example of an MDX statement: http://forums.olapforums.com/viewtopic. ... 324&p=7307

You can also use sort functions withing an MDX statement. Plaese see http://www.bihints.com/book/export/html/68 too.

Wim

Hi Wim,

In this form it was poor layout on my part, which i have fixed now.

Still learning about these active forms... Getting there though!

thanks for your help!

I am sure I will nedd to use this in the future, so at least i have a reference point!

vaneagle