Pivot with two same dimension

kavita25 — Sat, 16 Nov 2024 18:29:32 GMT

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.

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

topic Pivot with two same dimension in App Development