Exceptional Aggregation
Scenario: “Need to find out how many Sales Docs (Count) has been raised till date”.
Find the below “source & Expected result” information.
Source Information
Expected Query Output
Created a Normal Query (ZEA_Q001)
Steps Needs to be done in Query designer:
Step1: Create a “Formula” on top of the Key figure (Sales Value) using Exceptional Aggregation.
We can create “Exceptional Aggregation” only on “Formulas & CKF”, So in my case, I created a Formula (in order to make enable Exception Aggregation option) on top of this required key figure.
Step3: Check below in “Aggregation” tab I have selected “Exception Aggregation type” as “Counter for All Detailed Values” and “Reference Characteristic “ as “Sales Document”.
Step4: Check the below Created “Formula using Exceptional Aggregation”
“SAVE” & “EXECUTE”.
REPORT OUTPUT: Check the below Expected output in the below “Highlighted Column
(No Of sales Docs (Count))”.
Exception Aggregation: Whenever we need to summarize the key figure values based on some Characteristics, and then in that case, we can create this exception aggregation.
Like First Vlaue, Last Value and Count for All Detailed Values.
Condition: We can create Exception Aggregations only on CKF & Formulas