Hi, i am new here.
i got a pivot table as below. I wanted to create a macro able to filter base on what my input.
eg: if my input is =1701, then pivot will filter RGS_1701=Y, Rev_1701=Y,
if my input is =1701, then pivot will filter RGS_1702=Y,Rev_1702=Y.
Anyone can help on the macro script?? thanks in advance
i got a pivot table as below. I wanted to create a macro able to filter base on what my input.
eg: if my input is =1701, then pivot will filter RGS_1701=Y, Rev_1701=Y,
if my input is =1701, then pivot will filter RGS_1702=Y,Rev_1702=Y.
Anyone can help on the macro script?? thanks in advance
RGS_1701 | Y |
RGS_1702 | (All) |
RGS_1703 | (All) |
Rev_1701 | Y |
Rev_1702 | (All) |
Rev_1703 | (All) |