Webi 4.0: Use table block as an reference object for calculation
I have two tables.
First table - dynamic table.
Second table - static table.
First table displays data returned by the query (simple query - product dimension and amount measure), and also in that table i define product group based on the amount value. See example below
|1||500||=IF Amount <=1000 then "A", else "B"|
|2||1000||=IF Amount <=1000 then "A", else "B"|
|3||2000||=IF Amount <=1000 then "A", else "B"|
|4||3000||=IF Amount <=1000 then "A", else "B"|
In the second table i need to count how many products in each group. Result should be like this:
I tried to use different formulas: count(product), creating variable which define product group and try to count it. But i always get a wrong because i can't use results of table 1.formula 1 in my second table.
Can i use data that was calculated in another table? Can i use table as an reference object in another table?
If somebody know how to do it, i will be very grateful for your help.