Hi there - I'm having an issue creating a pie-chart in FM14.
What I'm trying to achieve is to represent a percentage of activity over a given period in a pie chart.
The accounts are listed in a drop down field as 'digital advertising, press, radio etc etc).
I am trying to create a calculation for each account and total these up for the period and represent in a chart.
Copies of what I am trying to achieve and the table are attached. Thanks for any help!