Use Pull up and header filters

Dear All,

I have the following use case: for each document I need to compare if the value is 5 times more than average for given vendor and highlight such positions. This I have already done using domain table (formula also includes certain exceptions given by the business). The only problem is that is always counts values globally and does not limit to the document range from date range selected. Is there any way to make it work, so that the average is calculated only from the range of selected cases?

Hi @ksitarsk,

I’m not sure how to answer your question directly, but did you have a look at the GLOBAL keyword? This can calculate the vendor average maybe in a different way, such that the time filter is considered automatically? (not sure, just thinking out loud :wink: )

Thank you for suggestion - I will have a look. Honestly, I have never used this before:)