Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

ProductAmountFormula 1
1500=IF Amount <=1000 then "A", else "B"
21000=IF Amount <=1000 then "A", else "B"
32000=IF Amount <=1000 then "A", else "B"
43000=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 GroupAmount
A2
B2

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!

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question