Hi,
I have a pivot grid that has for its columns a list of months, for its rows a list of brands and for its measures (msvalue and msvolume as cost).
I have created a custom aggregator to calculate the sum in a specific way for the Total Brands that means the vertical sum. For the Horizontal Sum which is for the Total Months, i would like to have another aggregator that calculates the Average. How can i do that? currently it is using the Custom Aggregator for the Total Brands and Total Months.
Thanks,
Nazha
Hello Nazha,
It has been a while since you have made your post, in case you still need support I will be glad to assist you further. I suppose the other community members can benefit from this answer as well. I have been looking into your post and I suggest you see this sample:
http://samples.infragistics.com/sldv/RunSamples.aspx?cn=pivot-grid#/pivot-grid/calculated-members
where it is shown how to achieve your goal.
Feel free to write me if you have further questions.