I have a WEBI report with multiple queries. The results are merged and a variable is created from two measures in separate queries. The variable displays and caculates correctly when the lowest level of detail is displayed in a report. But when I create a report at a summary level the calculated variable is blank.
For example the variable displays correctly at the item level but when the report is at the brand level it does not display. I have tried using Sum but that seems to make no difference.
Any help would be appreciated.