hi all, I'm trying to build a chart to display totals sold per artist in the current year.
I have a tables as below -
ARTWORKS (inventory) = INVOICE LINE ITEMS = INVOICES
then I have (as attached)
HOME (where charts are displayed in a slide control) = INVOICES LINE ITEMS | CHART (based on primary key and an unstored calculation of the invoice date from invoices to a gdate field that auto enters the year from get current year (as attached). The graph appears empty unless the c_Invoice_Year is turned into a text or number field and the numbers are added.
Can charts not work off unstored calculations?
Do this mean scripting an invoice date directly into the line items field every time an item is added and also if the invoice date is changed?