How to calculate average in Cryatal Analysis

Last Post 10 Jun 2004 06:13 AM by cgnr. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
cgnr
New Member
New Member

--
10 Jun 2004 06:13 AM
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
You are not authorized to post a reply.

Acceptable Use Policy