Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a very simple data model:
Product
Posting Date
Posting Month (derived from Posting Date)
Posting Year (derived from Posting Date)
Document Date
Document Month (derived from Document Date)
Document Year (derived from Document Date)
Amount
I would like to create a Pivot table:
So something like: Sum({$<Posting Year=,Document Year={Posting Year}>} _Amount)
Do I need set analysis for this, or can I achieve this in another way?
Create a canonical date from Posting date and Document date:
Create a calendar for that canonical date (Year and Month)
Filter for date type (document / posting) in your expressions.