Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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