aggregate to fiscal_year when base table is at fiscal_year/order/item granularity

aggregate to fiscal year based on orders > $10000 when base table is at order/item granularity

1reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • To do this currently, you will need to create a search with the following fields and save it as an aggregated worksheet.

    "order_id" "fiscal_year" "sales" "sum sales>10000"

    With that aggregated worksheet as a source, you should be able to create a search with the following fields to get the required result.

    "fiscal_year" "total sales"

    Like
Like Follow
  • Status Answered
  • 1 yr agoLast active
  • 1Replies
  • 311Views
  • 2 Following