Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello.
I've got this pivot table :
I'm trying to add a new dimension (it could be the first one in order) like this:
='Period: ' & min(Date) & ' / ' & max(Date)
It doensn't work !!!
Any suggestion ?
Thanks
Try this
=Aggr('Period: ' & min(Date) & ' / ' & max(Date), Period, Date)