Hello People,
I want to create a 100% stacked bar chart with following-
Dimension -
1) [EOM_Month] (Reporting data variable)
2) [Segment]
Measure
1) Sum of sale in each segment if the Event_date is less than EOM_Date
Graph - Stacked bar chart for each month, showing % of sale (if Event Date is less than EOM_Date) for each segment in respective month
I tried using total key word but it does not produce desired results using following exp.
sum(if ([Event Date] <= EOM_Date,[Sale]))
/
sum(total<EOM_Date>if ([Event Date] <= EOM_Date,[Sale]))
I have added[ EOM_Date] as dimension in Groups and [Segment] as Bar
Thanks,
SR
