Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have an excel weekly plan data, i want to show this data on a monthly dimension, showing the data relevant for the max week for each month
i tried using:
sum( Week={"=aggr(max(Week),Month)"} >} Data )
but i don't get the right results.
Anyone can help me please?
Thanks.
Try this:
sum( {< Week={$(=aggr(max(Week),Month)} >} Data )
HTH
Sushil
Try this
Sum({<Week={"$(=aggr(Max(Week),Month))"}>}Data)