Calculation

[#1]

i have calulated visit as per month Sum({<[month]={$(vmonth)}>}[visit])

but i want to calculate visit as per month as well as type.

that is visit of type abc,yre,cam,dec,others.

can i calculate change of visit by type as per month in same grapth.

i have attached excel sheet and qvw.

[#2]

Any responce any body

[#3]

Hi,

Did you try adding type as a second dimension in your chart in the attached example?

If this is not what you are looking for, could you pls. rephrase your question?

regards,

http://quickdevtips.blogspot.com/

[#4]

i have done as second dimension,but i have to show avg of type group ,without using dimension.

any other metod to do this.Sum({<[month]={$(vmonth)}>}[visit]) in this expression how can i add type,this will helpful.

[jagan]

Hi Shantnu,

Try Aggr like this

=Avg({<[month]={$(vmonth)}>}Aggr(Sum({<[month]={$(vmonth)}>}[visit]), month, type))

Hope this helps you.

Regards,

Jagan.