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