Using column value as column header dynamically

[chaitanyahublik]

Hi Guys,

I have sample data in QVD as attached spreadsheet. I want to build pivot out of this like 

State	City	O/N	1_day	2_day

Now Col1/2/3 will take expression from QVD as  SUM(<{Ref={MarketValue} BUCKETX}>)   .. where X = 1,2,3.  But for header , I want to display value of 2nd row i.e. Tenor which is dynamic and it can change everyday. 

For example , Col1 will have Tenor as O/N today but it can have tenor 1_day tomorrow. So its dynamicaaly to be shown in column header. ANy idea on how to get this dynamic header from column values ?

TIA.

[chaitanyahublik]

there was issue with excel upload, test data in QVD is as below 

State	City	Ref	BUCKET1	BUCKET2	BUCKET3
-	-	Tenor	O/N	2_day	3_day
FL	Miami	MarketValue	-59,885,058,092.9197	-893,231,883,433.0270	-204,406,740,331.6530
TX	Dallas	MarketValue	-1,117,544,734.9430	-15,443,447,252.8691	-2,780,508,149.9725
PA	Philadelphia	MarketValue	-	-	-
TX	Houston	MarketValue	-38,003,812,443.2863	-383,259,192,418.6180	-948,509,760.4878
GA	Atlanta	MarketValue	-	-143,171,900.9878	-134,870,299.6960
DC	Washington	MarketValue	-	-	-
MA	Boston	MarketValue	15,489,322,803.5416	30,011,122,926.9687	34,293,334,370.3408
WA	Seattle	CashflowAmtGBP	-	-	-
CA	San Francisco	CashflowAmtGBP	-168,766,486.1050	-5,584,362,669.0005	-1,456,089,884.4835
MI	Detroit	CashflowAmtGBP	-209,171,827.2647	-332,398,243.1590	-18,936,290.9839
CA	San Diego	CashflowAmtGBP	-	-	-
MN	Minneapolis	CashflowAmtGBP	-	-	-
FL	Tampa	CashflowAmtGBP	-21,553,471,049.2891	-69,652,991,402.2200	-42,600,152,380.6073