set analysis in bar chart

[adiarnon]

hi,

i have a bar chart with a dimension of month_sales

i have a mesaure of purchase that conect to a dimention of month_purchase

my chart dimention is month_sales and and the expression is aum(sale_amnt)

but,

i want to add a expression of sum(purchase_amnt)

but i need that the value where the month_sales dimension =11/2015

it will show the sum(purchase_amnt) where month_purchase=11/2015

* i dont want to change my schema

somthing like-

sum({Purcahse_MONTH={(Sale_Month)}>}SO_Purchase) ??????

[ali_hijazi]

sum(if(purchase_month=sales_month,purchase_amnt))

[ali_hijazi]

or sum({<Purchase_Amnt={"Purchase_Month = Sales_Month"}>}Purchase_Amnt)

[sunny_talwar]

May be this:

Sum({<SO_Purchase = {"=Purcahse_MONTH = Sale_Month"}>}SO_Purchase)

[adiarnon]

tnx,

but i tried both and its still not working

[ali_hijazi]

sum({<Purchase_Amnt={"=Purchase_Month = Sales_Month"}>}Purchase_Amnt)

[adiarnon]

not

[adiarnon]

Sum({<SO_Purchase = {"=Purcahse_MONTH = Sale_Month"}>}SO_Purchase)

what should i write SO_Purchase tha month or the amount?

[sunny_talwar]

What's a unique field in your data base which makes the combination of Purcahse_MONTH and Sale_Month unique?

[adiarnon]

no