Forum Discussion
Exception aggregation
Hi, I have a Pivot Table with a P&L account hierarchy. For some of the accounts, I need an exceptional aggregation other than sum. E.g. for the account Depreciation Tangibles, the MTD values should...
Hello dp32
You can create measures using time intelligence functions like LASTDATE, CLOSINGBALANCEMONTH, CLOSINGBALANCEYEAR, CLOSINGBALANCEQUARTER,
For this you would also need to create a calendar table.
Cheers!
Vivek
If it helps, please mark it as a solution
Kudos would be a cherry on the top 🙂
https://www.vivran.in/
Connect on LinkedIn