Query: cost_and_usage_actual_cost_by_service_dashboard_service_costs

select
  consumed_service as "Service",
  subscription_name as "Subscription",
  location as "Location",
  round(sum(cost_in_billing_currency), 2) as "Total Cost"
from
  azure_cost_and_usage_actual
where
  ('all' in ($1) or subscription_id in $1)
group by
  consumed_service,
  subscription_name,
  location
order by
  sum(cost_in_billing_currency) desc;