Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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???
May be use a Pivot table?
can you please provide same sample data
Thanks
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