Hello,
I have a date parameter which has a week split.
When I select Week 4 I need 4 bars(one for each week viz Week1, Week2, Week3, Week4) in a chart with sum of sales data.
When I select Week 3 I need 3 bars(one for each week viz Week1, Week2, Week3) in a chart with sum of sales data
and so on ...so when I select Week 1, i will have just one bar in my chart.
I tried using DATEDIFF with last() but I am not able to control the number of bars in the bar chart
I have attached a sample workbook.
5 answers
Hi.
Replace your Order Date Parameter calculation field with
[Order Date] <= [Parameters].[Order Date Parameter]