Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a table Year Month, Bucket and proposal_id .
I am trying to build a pivot table with 2 dimensions in it. One with Bucket for current year and second dimension with last year .
I am not able to get the desired output as seen in the attached excel sheet.
Need your help to define the dimensions/ expression to get this output.
@Mkelemen ,@ Sunny_talwar
Count of proposal_id | Bucket Current year | |||||||||||||
bucket Previous year | 0 | 1 TO 30 | 121 TO 150 | 151 TO 180 | 181 TO 365 | 31 TO 60 | 366 TO 450 | 451 TO 540 | 541 TO 730 | 61 TO 90 | 730 + | 91 TO 120 | #N/A | Grand Total |
0 | 8888 | 426 | 75 | 74 | 297 | 247 | 182 | 11 | 107 | 5165 | 15472 | |||
1 TO 30 | 34 | 20 | 10 | 10 | 74 | 15 | 45 | 16 | 1 | 9 | 188 | 422 | ||
121 TO 150 | 3 | 50 | 25 | 78 | ||||||||||
151 TO 180 | 1 | 3 | 18 | 27 | 21 | 70 | ||||||||
181 TO 365 | 2 | 306 | 84 | 392 | ||||||||||
31 TO 60 | 6 | 10 | 6 | 5 | 55 | 4 | 57 | 16 | 3 | 120 | 282 | |||
366 TO 450 | 1 | 1 | 83 | 57 | 142 | |||||||||
451 TO 540 | 7 | 142 | 149 | |||||||||||
541 TO 730 | 10 | 222 | 232 | |||||||||||
61 TO 90 | 2 | 1 | 4 | 5 | 30 | 2 | 82 | 5 | 3 | 113 | 247 | |||
730 + | 42 | 505 | 547 | |||||||||||
91 TO 120 | 1 | 1 | 1 | 11 | 46 | 31 | 91 | |||||||
Grand Total | 8932 | 457 | 96 | 95 | 459 | 268 | 201 | 114 | 334 | 219 | 154 | 122 | 6673 | 18124 |
This output is for prev(Feb 19 )and current (feb20 )
basically i want show count of proposal_id in pivot table One with Bucket for current year and second dimension with last year.
All previous year proposal_id count with current year all possible count of proposal_id .
Regards,
kavita