Check sales based on dynamic filters, starting from a default condition

[rm1]

Hello everyone,

I need a hint to perform a calculation based on selections applied to my report.

I have different levels of segmentation: BRAND, PRODUCT LINE, PRODUCT, etc

Now, I need to check sales based on the selected segmentation level. But I need to choose also a specific default level if nothing is selected. How can I write a formula that says "if segmentation is not specified use product level as default, otherwise use the selected level"?

I thought something like: sum({$ < segmentation=p(segmentation) > }sales), but I need to add the default condition of product level.

Thanks in advance for any help!

[w0jt4z]

I use the extension "SimpleFieldSelect". This extension allows to set default Value of my dimensions.