Help needed with formula

I’m trying to build a chart that displays the total value of items sold each day.

I’m retrieving the data from a “sales” database, that has the following fields:

  • Quantity
  • Sales_price
  • Sold_date

On the X axis the date, so each database entry has it’s date so there are multiple entries with the same date, so i want to show the date grouped by Sold_date, interval 1 day.

and on the Y axis the total value sold per day,

So i was thinking of something along the lines of:
list 1: each item’s Quantity grouped by sold_date
list 2: each item’s sold_price grouped by sold_date

the issue is it seems that that doesn’t work as it doesn’t propose me to group it by date.

Does anyone know how i’m supposed to do this ??

This topic was automatically closed after 70 days. New replies are no longer allowed.