Quarters data in set analysis?

[skumarqv11]

Hi Folks,

I have my data like below.for each quarter we have the sales.and in the master calender also i have only quarter dates(i.e only 5 YearMonths)

Quarters:	Sales
%YearMonth	Sales
Dec-16	100
Sep-16	200
Jun-16	300
Mar-16	120
Dec-15	110

I need a output for Each month i want to show the data like below. i am creating 5 expressions for each yearmonth but its not working fine.

Dim	Dec-16	Sep-16	Jun-16	Mar-16	Dec-15
A	100	100	0	40	40
B	0	100	100	40	70
C	0	0	200	40	0

Please Suggest me the approach???  

[sunny_talwar]

May be use a Pivot table?

[krishna20]

can you please provide same sample data

Thanks

[rahulpawarb]

Hello Shravan,

I agree with Sunny! However, please share some sample data/script you used, if possible. This will help us to further analyze this issue.

Regards!

Rahul