Calculating the difference in Value when we select two weeks dynamically

[#1]

Hi All,

I need to calculate difference of two weeks for all expressions in a pivot table. There are about 10 expressions. always there are two weeks selected. The selection of week should be dynamic. I created two variables for min and max week but unable to add difference.

Thanks in advance for your help.

Please see the data and output example in attached file.

Regards,

Veman Reddy

[#2]

Hi John,

Thanks for your reply,

Here the rule to follow is:

1. If we select 3 months say 1,2 and 3, then need to display the rows whcich is having only revenue for one month. the order of the row is 1st show revenue having fonly or 1st month, then second month and then 3 rd month.

2. Then it comes two months criteria, it should display the revenue having for both 1st and 2nd then 2nd and 3rd.

3. Then all the 3 months.

means we are showing, revenues only for one month at top then revenue for 2 months and then revenue for 3 months

Thanks in advance.

Best Wishes,

Veman Reddy