How we can display field row values as column headings

[#1]

Hello Every one,

I was trying to display field values as column headings( horizontal format) and that column field value as with "Trend" hyperlink.

If I click Trend hyperlink it should be display the line chart .

please see the attached images for your understand and suggest me how we can achieve it.

Thanks

Swathi

[#2]

ok thats fine Thanku so much.

Coming to the 2nd question If I click on trend I need to display line chart with dimention as FISCAL WEEK and expression as Sum(No Of Receipts).

For this I have added calender table to my datamodel and tried to create chart it but I am unable to succeed can you pls check once.

Thanks

Swathi

[JonnyPoole]

I'm not sure !  You will have to tell me the following:

Which field in your data model  shows multiple dates (or weeks) ?

Which field in your data model represents the receipt ID ? 

THis wasn't obvious to me.

[#4]

the field FISCAL_YEAR_WEEK_NUM filed of Calender table(attached table) shows the weeks .

Metric column represents different values (like No of receipts,AWLT,AVG STD.LEADTIME....etc)

thanks

Swathi

[JonnyPoole]

ok. i joined the new data set to the existing on LAST_UPDTD_DT  . i needed to wrap it in a date() function to do so. attached

But i don't see how i count the receipts.  the metric column has 'no of receipts' for example, but which other field gives you the number for the receipts ?  Also LAST_UPDTD_DT and fiscal date appear to be 2 different things. If you need to report metrics on a fiscal date (or week) basis, you'll need to add fiscal week to the main data table or add the number of receipts to the 'calendar' table.