Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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 |