View the original community article here
Last tested: Feb 9, 2021
Even if you have a value in the pivot subparameter of your query parameter, queries with pivots need to have the pivot defined in both pivots AND in dimensions.
Example:
query: orders_by_brand_name {
dimensions: [products.brand, products.category]
measures: [products.count, order_items.order_count]
pivots: [products.category]
description: "Orders by brand name"
limit: 500
}
You can see that products.category is included in both the dimensions and pivots subparameter.
This content is subject to limited support.