dimensions and conditional show based on expression value

[Anonymous]

Hello,

I want to use a text field to limit the shown dimensions in my pivot table (from all_order to only open_orders)

something like this in the conditional show for dimensions:

if(vShowOpenOrders = 1 , ( sum(TotalQuantity) - sum(ProcessedQuantity) ) > 0 , )

I know I can achieve this using a conditional aggr function. But then I would need to apply this logic to every formula I use in the table, right?

any help is appreciated,

thanks,

Lucas

[zhadrakas]

Hello,

usually you have a Status field in your data model that does this Job for you.

If not i would recommend you to precalculate that in script and generate a field like STATUS.

This way you can create a Listbox with STATUS and easy Switch between "open-" and "all orders".

Regards

tim

[Anonymous]

I see your point. This would mean I need to group my data and lose a lot of other information. Or I need to create a separate table with this information.

I probably need to do this if I cannot find a solution including the conditional show for the dimension.

Thanks