How to calculate the total amount before and after aggregation?
Product name, quantity and amount
defining the formula at local level
Total amount= product quantity x amount
It will give out put like means total amount not yet aggregated it is giving product quantity x product price = total amount
Now report output but achievement total amount should be aggregated value.
Creating global level calculated key figure
Creating KF at Global level
Here not using exception aggregation
This Total amount KF defined at global level
global level calculated KF will appear the calculation after aggregation
Output should be below report
After un check the calculation after aggregation means before aggregation it will give total aggregated total amount value.
Output of the report now showing total amount was aggregated
Now report out put total amount is given aggregated value.
hope it will help beginners.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
6 | |
5 | |
5 | |
5 | |
5 | |
4 | |
4 | |
4 | |
3 | |
3 |