Bar Charts or Line Charts from PIVOT Table

Hello,

Yes, I believe so.  Reference the following post where @Del  created a dashboard Chart from a Pivot Table that Pulls the Customer Name, the Posting Period and the Order Number for last year and this year from a Generic Inquiry. 

Laura

As far as I can tell Acumatica doesn’t show pivot tables as a source for a chart.

You should be able to create your chart using the same GI as the pivot table to create your chart. 

@Del  Yes, I created a pivot table from the GI, but the screen ID doesn’t appear in the chart. I'm unable to retrieve values from the GI to prepare a bar chart that compares current period sales with budgeted, received, and shipped amounts by salesperson and location. Although I achieved this comparison in the pivot table, I can't generate the chart directly from it.

Hi ​@jvarughese23 were you able to find a solution? Thank you!