Tabular set question...

[jjones_stats]

Let's say I have a company that sells apples and oranges and I would like to market a specific group of my customers.

Using a tabular set, I would like to create a list of customers that have purchased more than 100 apples but fewer than 10 oranges in the last quarter.

So far I can generate a list comparing apples to apples or oranges to oranges, but I can't seem to compare apples to oranges...sorry about the cliche....any thoughts?

[BIsrik]

Firstly is the apples and oranges are within the same field in database. if so, then why do u want tabular set..Using charts solves ur analysis. If not, then lets assume there are 4 fields as customers, apples, oranges and qty. take the customers,apples and qty in one TM, and customers,oranges and qty in another TM. use the Union operation in TS. Then use any of the report type and do your analysis.

But what keep tricking my mind is how is the table structure of that company. What would be the values in apple and orange field(if so).

Srik

[jjones_stats]

Apples and Oranges ARE in the same database field. I can use charts for analysis but in this case I want a list of specific customer numbers.

[BIsrik]

U can do that also in the charts itself...

Srik

[Darek]

Use two Tabular Models as children and do a join between them using cust# using filters. Quantities filter should be applied at the same level.