How to Calculating the Average Quantity using the Fixed LOD?
1. In this example I am using the sample records of Billing Details data.
2. Drag Order Number into Rows.
3. Drag the Order Date into Rows and select the MDY(Order Date).by right click on the Order Date select the MORE in that select Custom option then it will open the Custom Date window in that select Detail drop down and chose Month/Day/Year.
4. Drag Quantity into Rows and select the aggregation type is SUM and change Continuous to Discreet.
5. And Drag the Bill Number and select the aggregation as Count (Distinct) .
6. Drag Quantity into Label (Text) at marks card level. And change the Aggregation as AVG.
7. The final output is shown below.