Queried Columns are not coming in Pivot table

Hi,
This is Mahesh. I am trying to get the data from the DB using "Excel Data
Connection" excel pivot table.
In the query I am querying last 7 days, last 4 weeks, last 2 months data
from the DB. To identify the daily, weekly and monthly data i am prefixing
some text (eg: T-1day, T-2day, T-1Month). I am not getting that extra column
when i am importing the data in pivot table.

Please help me on this

Thanks,
Mahesh