Query 1311 Top 10 Customer Sales

Base Application, Microsoft.Sales.Customer

src/Layers/W1/BaseApp/Sales/Customer/Top10CustomerSales.Query.al37 lines, Copyright (c) Microsoft Corporation. MIT

// ------------------------------------------------------------------------------------------------// Copyright (c) Microsoft Corporation. All rights reserved.// Licensed under the MIT License. See License.txt in the project root for license information.// ------------------------------------------------------------------------------------------------namespace Microsoft.Sales.Customer;using Microsoft.Sales.Receivables;/// <summary>/// Retrieves the top 10 customers ranked by sales amount in local currency./// </summary>query 1311 "Top 10 Customer Sales"{    Caption = 'Top 10 Customer Sales';    DataAccessIntent = ReadOnly;    OrderBy = descending(Sum_Sales_LCY);    TopNumberOfRows = 10;    elements    {        dataitem(Cust_Ledger_Entry; "Cust. Ledger Entry")        {            filter(Posting_Date; "Posting Date")            {            }            column(Customer_No; "Customer No.")            {            }            column(Sum_Sales_LCY; "Sales (LCY)")            {                Method = Sum;            }        }    }}