<p>I wonder if someone might be able to help me out here. I am trying to create a report that shows internet traffic by category with a trend line on the total amount. Here is a snippet of my data:</p>
<p> </p>
<div>Week Source Count</div>
<div>9/14/2014<span> </span>Facebook<span> </span>12</div>
<div>9/21/2014<span> </span>(not given)<span> </span>2</div>
<div>9/21/2014<span> </span>Facebook<span> </span>10</div>
<div>9/28/2014<span> </span>(not given)<span> </span>4</div>
<div>9/28/2014<span> </span>Facebook<span> </span>17</div>
<div>10/5/2014<span> </span>(not given)<span> </span>1</div>
<div>10/5/2014<span> </span>Facebook<span> </span>19</div>
<div>10/5/2014<span> </span>Other<span> </span>2</div>
<div>10/5/2014<span> </span>Web Form 1</div>
<div> </div>
<div>The categories are variable so I can't do a dataset with the categories as fields.</div>
<div> </div>
<div>I have attached a snippet of the chart that I have created from this data. I have the Source field set as the "Optional Y-series Grouping" for the chart. All of this is good so far.</div>
<div> </div>
<div>What I want to do is to have a trend line (4 week moving average) on the total amount of leads.</div>
<div> </div>
<div>I have a cross tab that presents the data more or less the way I want it. But I can't get that into chart form with the total amount of leads showing as the trend line.</div>
<div> </div>
<div>Thanks in advance for any help.</div>
<div> </div>
<div> </div>
