July 15, 2008, 03:12 PM
Jason K.Using OLAP Tab drop-downs with aggregated data?
I have a tabbed olap report over sales data by day, by salesperson.
If I wanted to show only the values on this report where the days sales were under $10,000 (not where the salesperson's daily sales were under $10,000) how would I do that?
When we load the drop-down of all available sales values in OLAP, it shows only salesperson-per-day values, which are all much less than $10,000, even if the report is SUM SALES BY DAY
Does this make sense?