Skip to main content

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
0/9000