How to insert new rows in data values in pivot table

[Lucky1]

I have a pivot table 

Id Name

1 aa

2 bb

I have a filter item

Item

Apple

Banana

If I select apple my pivot table should create one row and my output table should show like below

Id name

Apple

1 aa

2 bb

How to do that

[Kushal_Chawda]

@Lucky1  did not understand what you are looking for. Could you represent expected output in better way?

[Rohan]

Hi,

Will you be selecting only one value from the filter every time or are multiple selections possible ?

if only single selection, then add another dimension before ID with the Filter Dimension & use the following in the show column if condition : getselectedcount(Filter)>0

Let me know if this helps you out.

Thanks & Regards,

Rohan.

[Lucky1]

 this is how my output should show Apple is value in my item filter.confidential is normal test

[Kushal_Chawda]

@Lucky1  is there any link between Item and ID? How do filter of Apple affects ID & Name?

[Lucky1]

Sorry kushal,

I understand requirement wrongly.I have dynamic title(when I select filter my title will change based on filter selection.)so when I download my pivot table into Excel the data is downloading correctly but the title is not downloading.I want to download my table into Excel along with title