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) ??????
I guess are you able to share a sample?
i cant
by this is my scheme

sum({<SO_SAVE_MONTH={"(=SO_SAVE_MONTH=[Save Month])"},[Actual Calc]=,Year=,Month=>}SO_QTY_DEL)
this is the expression im tring to built
my dimention is [Save Month]
and i need the sum(SO_QTY_DEL) in this month but with SO_SAVE_MONTH
i cant insert the SO_SAVE_MONTH to the key table...