expression to write for a chart

[Anonymous]

my data model is as follows :-

I have 3 tables :-

1. POS_Master_all

2. Material_Master

3. store_Mapping

Here in the above master table the business is based on seasons(winter,summer,autumn,spring) and year now i want an expression  to show sales in a bar chart based on seasons 

need an expression to depict sales and dimension in a bar chart would be (distribution channel, category, gender).

[techvarun]

The problem is nice to solve with some sample data, expected result or a qvw file. share something if possible

[MayilVahanan]

Hi

You can use

Dimension : Seasons

Expression :Sum(Sales)

Dimension: May be create cyclic group with distribution channel, category, gender

Expression :Sum(Sales)

[Anonymous]

I need a single expression to be created for any season which users enters in dashboard

[Anonymous]

2014 year(expression written on bar chart )

=num(

sum(if(Sold_Date <= MakeDate(Prev_Year,month(To),day(To)) and Sold_Date >= MakeDate(Prev_Year,month(From),day(From)),  [inv value]))/Sales_INR_Unit,

'#,##0.0')

2014 season

=num(

sum(if(Sold_Date <= MakeDate(Prev_Year,month(To),day(To)) and Sold_Date >= MakeDate(Prev_Year,month(From),day(From)) and [Season Code] = $(vSales_Summary_Previous_Season),  [inv value]))/Sales_INR_Unit,

'#,##0.0')

I need a combined expressions for all seasons and particular year