particular dimension

marcorizzo — Thu, 04 Feb 2016 16:26:15 GMT

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

Re: particular dimension

yura_ratu — Thu, 04 Feb 2016 18:22:22 GMT

Try this

=Aggr('Period: ' & min(Date) & ' / ' & max(Date), Period, Date)