Property Control to change cross table axis

[Sedat Diken]

Hi,

I'm a fledgling Spotfire developer who is putting an incredible weight in learning. I'm tasked to build several dashboards that requires to leverage from Property Control, and I apparently managed to build dependent property controls.

Anyway, I've been trying to find a way out changing the cross table axis dynamically using property control, but what makes my requirement different is that I have a fixed column in the horizontal axis and I need to insert Year or Month based on what is selected in the drop-down property control while keeping the fixed column.

The underlying data is in attachment, also please refer to the attached cross table illustrations.

I tried to use Set From Property and choose the drop-down property control but it is removing the fixed column (Sahada Bulunmama Nedeni -ToT) and put Year or Month in the horizontal axis. I need to keep the fixed column while inserting Year or Month. It should look like Year or Month -> ToT.

I would really appreciate if someone can help me with my requirement.

Kind Regards

[Sedat Diken]

Any idea :)

[Sedat Diken]

Well, Custom Expressions can come in handy. :) Apparently, I need to learn more about Custom Expressions. Below line worked like a charm.NEST is what helped me to pull this off.