Hi guys, I have a problem with filters. I will try to explain it through an example.
I have a sales report of different products. I filter the sales revenues based on some condition. (i.e. sales greater than 5,000). As a result, I see a subset of products having this condition.
As a next step, I would like to use this subset of products as a filter in another report. For example I would like to show another report (as a codisplay) which will be filtered according to the products of the previous report.
The problem, this subset of products is not filtered on products, but on another field (sales).
Do you think this is possible with current infrastructure? (Using values of a field as a filter in another report)
If not, can you develop it? :)
PS: Actually my current use case is with Top N Advanced function. I show products with top N values. I would like to use the products as filter in another report.