how to set default field value

[#1]

Hi there

How can i set the 3 charts default to "BT" without need to click on the button "BT"

where the field is "ct" and value is "b"

i tried use the expression =ct='b' in the dimension but doesnt work.

Thanks

[jagan]

Hi,

Try like this in dimension

If(ct='b', ct)

Hope this helps you.

Regards,

Jagan.

[jagan]

or you can handle in your expression like below

Sum({<ct={''b}>} MeasureName)

The above expression is a sample you can change it accordingly.

Regards,

Jagan.

[#4]

Hi,

To set a default field value, we can actually use a trigger in sheet properties as shown below.

So whenever you are navigating to that sheet, by default the field 'ct' will be set to 'B'.

Regards,

Vivek