Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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).
The problem is nice to solve with some sample data, expected result or a qvw file. share something if possible
Hi
You can use
Dimension : Seasons
Expression :Sum(Sales)
Dimension: May be create cyclic group with distribution channel, category, gender
Expression :Sum(Sales)
I need a single expression to be created for any season which users enters in dashboard
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