report format: reflect the table fields as a header

[#1]

My data looks like this :

type	year	quarter	week	count
assessment	2016	Q1	57	500
bridging	2016	q2	58	6000

I need it to look like this instead

name	2016	jan	quarter	week 57
bridging	5000	5	60	1
assessment	15000	15	800	15

Any guidance will be deeply appreciated please

[Gysbert_Wassenaar]

Well, you'll have to explain first how 6000 turns into 15000 and 15 and 800 and 15 and where the field jan comes from.

[sunny_talwar]

How is your raw data? Would you be able to share a sample here?

[#4]

Hi.

Ultimately I need to take the data and instead of displaying horizontal I need to make it display vertically and allow for the headers to then have a drop box..

I am really bad at trying to explain this... but I will try

[#5]

How Do I attach files here?

[#6]

So I have the following fields:

Year

Month

Quarter

week of year

each dimension with an expression : showing me total clients per year, month, quarter, week of year this is

done vertically , I need to change to format to represent it in a horizontal format.

[sunny_talwar]

Look here:

Uploading a Sample

[#8]

Morning

I have attached the sample data , thank you

[ganeshsvm]

Do you need something like this?

[#10]

Hi

I require it to look like this:

Br Intervention	2016	Dec	Week : 48
Bridged	15	4	1
Other forms	10	0	0

So where the year column is, it would reflect the actual current year we are in with the drop down list

month would reflect the current month we are in  as well as the drop down list to change to a different month

week to would reflect the current week we are in as well as the drop down list to change to other weeks

The counts would then reflect the under the appropriate year , month and week respectively.