problem with a chart (set analysis)

[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) ??????

how can i do it?

hope im clear

[Chanty4u]

sum({<Purcahse_MONTH={$(Sale_Month)}>}SO_Purchase)

[swuehl]

* i dont want to change my schema

I think that would indeed the best solution, see Canonical Date

[adiarnon]

not working

[adiarnon]

i dont want to change my schema

[Chanty4u]

chk dis

A Primer on Set Analysis

Why is it called Set Analysis?

[adiarnon]

any more ideas?

[Kushal_Chawda]

I think the best way is already suggested by swuehl‌.

You can try this as well by creating the table. For that You have to change the schema.

Sales:

load Sales_amount as Amount,

       Sales_Month as Month,

       'Sales' as Flag

From table;

concatenate

load Purchase_amount as Amount,

       Purchase_Month as Month

       'Purchase' as Flag

From table

[jagan]

Hi,

Try

sum({<Purcahse_MONTH=P(Sale_Month)>}SO_Purchase)

Regards,

jagan.

[sfatoux72]

Try that:

sum({<Purcahse_MONTH={'$(Sale_Month)'}>}SO_Purchase)