Expression and week aggregation help

[Anonymous]

I need to put a week bucket slider upto four weeks, when the slider is on 1st week the week total expression should calculate only one week total, when we move the slider to two weeks it should calculate the total for 2 weeks... so on.. Please see attached screen shot and attached QVW file.. Thanks for your help in advance.

[Anonymous]

sunindia‌ MRKachhiaIMP‌

[maximiliano_vel]

What happens with the other columns when you select 2 weeks for example? do they change accordingly or should ignore the week selection?

Regards

[antoniotiman]

Hi Vinay,

see attachment.

Regards

[Anonymous]

Thank you Velez and Antonio for your quick response, i will update an excel sheet with how the output should look like..

[Anonymous]

This is how my out should come like.. see attached excel sheet.. Thank you for your help

[antoniotiman · Accepted solution]

Vinay,

see attachment.

You can add further If() according number max of weeks

Regards

[Anonymous]

hi Antonio,

Please see below screen shot

[antoniotiman]

See Column 'Week Total New'

[Anonymous]

any help..