How to create Graph chart

Question

211698-help2.pdf

NEED TO CREATE GRAPH

Answer 1

Hi @Lily

As the chart header is PAST PRACTICE TERMS 12 WEEK TREND, and there are 12 Friday dates on X-axis, ars there the date in your source table?
If so, can you show us for better analysis?

At current time, I would suggest you try Pivot Table Chart.

• You can drag the Sales Rep into Filters area, drag the date fields into Rows area, and drag $ PP Term into Values area.
• Then select the pivot table > Go to PivotTable Analyze > Caculations group > Fields, Iterms & Sets > Caculated Field > Create a new field called "% of AR" like following imge. And drag this filed into Values area.
  

Any misunderstandings, you can let us know.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

---