Pivot Table

[#1]

Hi ,

I need to show the data in a pivot table in the format attached.

I am having 3 dimensions(ProductiveType,TotalHours,Engagements) and a rolling3months as a field.

I need to analyse the data for the past 3 months in the format attached.

Please suggest.

Thanks,

Srihari.

[renjithpl]

hi can you just show your table structure or send raw data in excel format. ?

[#3]

Hi,

I suggest that you put the engagements and months as dimensions.

expressions should be only 2 (sum of productive time as percentage and for the n prod you can have the formula of sum of total hours - sum of productive time)

If ever that you have all months you can just select the 3 months that you would like to see and the table would adjust into those months.

Hope this helps..

[#4]

Hi,

Please find the sample XL file attached.

I am calculating the Rolling3Months in the load script.

Thanks,

Srihari.

[#5]

Please see attached file for a sample based on what you have given us.

Hope this helps..

[renjithpl]

Hi Guys,

Added little bit and attached the qvw file, hope this hepls.

Thank you

[#7]

Hi!

You can use renjithpl's file as he added dates already 🙂

Thanks!

[#8]

Thank you Wilnard and Ranjith for your help