RE: Order Stacked Bar Chart by Summed Field
Thank you Hao.
Yes I had used that link also but still not working by adding that code line, see below:
<datadefinition>
<fetchcollection>
<fetch mapping="logical" aggregate="true">
<entity name="cr3c4_vi_dy_openbookings">
<attribute name="cr3c4_flightdate" groupby="true" alias="_CRMAutoGen_groupby_column_Num_16" dategrouping="day" />
<attribute name="cr3c4_grosswt" aggregate="sum" alias="_CRMAutoGen_aggregate_column_Num_13" />
<attribute name="cr3c4_agent" groupby="true" alias="_CRMAutoGen_groupby_column_Num_14" />
<order alias="_CRMAutoGen_groupby_column_Num_16" descending="false" />
<order alias="_CRMAutoGen_aggregate_column_Num_13" descending="true" />
</entity>
</fetch>
</fetchcollection>
<categorycollection>
<category alias="_CRMAutoGen_groupby_column_Num_16">
<measurecollection>
<measure alias="_CRMAutoGen_aggregate_column_Num_13" />
</measurecollection>
</category>
</categorycollection>
</datadefinition>