Pivot table column changes dynamically based on Selections

[siva_boggarapu]

Hello Everyone,

I have customer requirement where customer select days from Filter pane . Based on selection days Pivot Table columns has to be changed dynamically 

Days	Accounts
1	100
2	500
3	579
4	235
5	456
6	213
7	153
8	259
9	153
10	123

Days	1	2	3	4	5	6	7	8	9	10
>1					-	-	-	-	-	-
>2	100
>3	-			235	456	213	153	259	153	123
>4	-	-	-	-	456	213	153	259	153	123

From Above selection lets Say if customer select 6 value, Pivot table should display Days 1 to 5 columns like below 

Days	1	2	3	4	5
>1					-
>2	100
>3	-			235	456
>4	-	-	-	-	456

Similarly   If customer select 8 value 

Days	1	2	3	4	5	6	7
>1					-	-	-
>2	100
>3	-			235	456	213	153
>4	-	-	-	-	456	213	153

Please could any one help out 

Regards,

Siva