Using DP Information Item as alternative to Table Interface
We have a query, and one of the columns in that query is LY Sales Variance.
The calculation for that column has been added in the query designer and works correctly on a detailed level.
In addition, conditions have been applied, to show the Top N Vendors per Division ... the condition also works fine.
The result of this is a report which shows the Top 3 vendors per division, and a number of columns. As mentioned, the LY Sales Variance calculates correctly on a detailed level, but (and here is the problem) not at a <b>results</b> level.
The <b>results</b> level (and overall result as well) calculation seems to perform the calculation without the condition applied.
Any documentation on this or ideas would be greatly appreciated.