I have some calculated values such as average sale, runningsum, and count of items in a table which you can see in the attached picture below.
I am trying to figure out a way to use those calculations to fill another table since I will have many of these tabs for different products.
So the idea is to take all of these calculated values and populate them into a separate summary table and then chart that information.
This may not be possible in Webi, however, I know that if it is, this community will help!
Can you give an example of what your final table is going to look like? Maybe I’m oversimplifying this but if you just had a table with the Product dimension and the sum, count and average measures wouldn’t that give you what you are looking for?
you have to reflect that a calculation in a table is executed per line/row and so splitted out by the dimensions used in the table and at the other hand if you use a standalone calculation, it is possible it will not react/calculate the same way, so you will have to use in some cases other formulas
Can you give an example of some of other formulas that might make this work?
best way is to go case by case
Can we look at it on this case? I think I can work my way through the rest of them if I can get some help on the first one.