# Webi 4.0: Use table block as an reference object for calculation

Hi, experts!

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

Product | Amount | Formula 1 |
---|---|---|

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:

Product Group | Amount |
---|---|

A | 2 |

B | 2 |

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.

Thank you!