Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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) ??????
sum(if(purchase_month=sales_month,purchase_amnt))
or sum({<Purchase_Amnt={"Purchase_Month = Sales_Month"}>}Purchase_Amnt)
May be this:
Sum({<SO_Purchase = {"=Purcahse_MONTH = Sale_Month"}>}SO_Purchase)
tnx,
but i tried both and its still not working
sum({<Purchase_Amnt={"=Purchase_Month = Sales_Month"}>}Purchase_Amnt)
not
Sum({<SO_Purchase = {"=Purcahse_MONTH = Sale_Month"}>}SO_Purchase)
what should i write SO_Purchase tha month or the amount?
What's a unique field in your data base which makes the combination of Purcahse_MONTH and Sale_Month unique?
no