<p>Hi,</p>
<p> </p>
<p>I have made some aggregation in a table. Now I want to use the data in table in some other charts and tables. the requirement is that each chart and table has a different level of aggregation. If I use this parent table as a dataset/report item, all the filters and aggregation gets disabled in the charts properties</p>
<p> </p>
<p>My question is whether its possible to use a tables data as a dataset and further aggregate/apply filter over that in other charts/tables</p>
<p> </p>
<p>If this is not possible, what are the alternative solution. The problem in my case is that I have around twenty charts and then I have to create these aggregations seperately in each chart and table</p>
<p> </p>
<p>I am using a scripted dataset so I am also finding it hard to do the aggregation in the dataset as I dont know how to do the aggregation in a scripted dataset</p>
<p> </p>
<p>Regards</p>
<p>Shah</p>
