I am using Crystal Analysis 8 version. I have a cube with a time dimension,items dimension. What i need is to calculate is the totals and average of all the selected products for a selected time diemnsion. That is lets suppose There are 3 items selected in the item dimension and three months selected in the time dimension. I got these 34,10,12 as the itemqty for each item for that selcted time. Item qty is the measure. Now i need to calculate the totals and the average. I could calculate the totals by using the Automatic totals option in CA but i don't have an option to select that totlas field to calculate the average..Like here it should be total/3 for average.
ITems Jan Feb March Total Average
item1 34 10 12
item2 3 94 32
item3 23 3 12
any idea how this could be done?
Thanks in advance