Hello,
I want to be able to show lines of data in a table where a particular value is different to the previous months value. I have tried the below however is does not work.
=If({<[Reporting Date]={'$(=monthend(MAX([Reporting Date]),-1))'}>} [Coverage Group (All)]=[Coverage Group (All)],'',Item_ID)
The dates used are the last day of each month hence the Monthend part.
[Coverage Group (All)] will show values a b c d; and if this month is different to last month I want to show it, otherwise i do not want it included.
any ideas?