Group and filter options in Cost analysis

Cost analysis has many grouping and filtering options. This article helps you understand when to use them.

To watch a video about grouping and filtering options, watch the Cost Management reporting by dimensions and tags video. To watch other videos, visit the Cost Management YouTube channel.

Group and filter properties

The following table lists some of the most common grouping and filtering options available in Cost analysis and when you should use them.

Property When to use Notes
Availability zones Break down AWS costs by availability zone. Applicable only to AWS scopes and management groups. Azure data doesn't include availability zone and will show as Not applicable.
Billing period Break down PAYG costs by the month that they were, or will be, invoiced. Use Billing period to get an accurate representation of invoiced PAYG charges. Include 2 extra days before and after the billing period if filtering down to a custom date range. Limiting to the exact billing period dates won't match the invoice. Will show costs from all invoices in the billing period. Use Invoice ID to filter down to a specific invoice. Applicable only to PAYG subscriptions because EA and MCA are billed by calendar months. EA/MCA accounts can use calendar months in the date picker or monthly granularity to accomplish the same goal.
Charge type Break down usage, purchase, refund, and unused reservation costs. Reservation purchases and refunds are available only when using actual costs and not when using amortized costs. Unused reservation costs are available only when looking at amortized costs.
Department Break down costs by EA department. Available only for EA and management groups. PAYG subscriptions don't have a department and will show as Not applicable or unassigned.
Enrollment account Break down costs by EA account owner. Available only for EA billing accounts, departments, and management groups. PAYG subscriptions don't have EA enrollment accounts and will show as Not applicable or unassigned.
Frequency Break down usage-based, one-time, and recurring costs.
Invoice ID Break down costs by billed invoice. Unbilled charges don't have an invoice ID yet and EA costs don't include invoice details and will show as Not applicable.
Meter Break down costs by usage meter. Purchases and Marketplace usage will show as Not applicable. Refer to Charge type to identify purchases and Publisher type to identify Marketplace charges.
Operation Break down AWS costs by operation. Applicable only to AWS scopes and management groups. Azure data doesn't include operation and will show as Not applicable - use Meter instead.
Pricing model Break down costs by on-demand, reservation, or spot usage. Purchases show as OnDemand. If you see Not applicable, group by Reservation to determine whether the usage is reservation or on-demand usage and Charge type to identify purchases.
Provider Break down costs by AWS and Azure. Available only for management groups.
Publisher type Break down AWS, Azure, and Marketplace costs.
Reservation Break down costs by reservation. Any usage or purchases that aren't associated with a reservation will show as Not applicable. Group by Publisher type to identify other Azure, AWS, or Marketplace purchases.
Resource Break down costs by resource. Purchases show as Not applicable, because they're applied at an EA/PAYG billing account or MCA billing profile level and not associated with a specific resource. Group by Publisher type to identify other Azure, AWS, or Marketplace purchases.
Resource group Break down costs by resource group. Purchases, tenant resources not associated with subscriptions, subscription resources not deployed to a resource group, and classic resources don't have a resource group and will show as others, classic services, $system, or Not applicable.
Resource type Break down costs by resource type. Purchases and classic services don't have an Azure Resource Manager resource type and will show as others, classic services, or Not applicable.
Resource location Break down costs by location or region. Purchases and Marketplace usage may be shown as unassigned, unknown, unmapped, or Not applicable.
Service name or Meter category Break down cost by Azure service. Purchases and Marketplace usage will show as Not applicable or unassigned.
Service tier or Meter subcategory Break down cost by Azure usage meter subclassification. Purchases and Marketplace usage will show as Not applicable or unassigned.
Subscription Break down costs by Azure subscription and AWS linked account. Purchases and tenant resources may show as Not applicable.
Tag Break down costs by tag values for a specific tag key. Tags aren't available for: purchases, tenant resources not associated with subscriptions, subscription resources not deployed to a resource group, or classic resources. Some services don't include tags in usage data. Learn more about tags support for each resource type.

For more information about terms, see Understand the terms used in the Azure usage and charges file.

Next steps