dimenssion

[omid5ive]

i want to use sth like this in my dimenssion:

max(date)

how can i do it?

i have some table like below:

company	sales
a	1
a	2
b	3
c	4
d	5

i want pevot like below:

company	Header 2
a	2
b	3
d	5
c	4

i should use sale field in dimenssion

[giakoum]

aggr(Max(sales), company) as calculated dimension

[hemanthaanichet]

Hi Omid,

select dimension as company

in expression write as max(sales)

u may get ur requirement

for reference pls have a look in to my attachment

Regards

Hemanth

[Chanty4u · Accepted solution]

try below then

add in caluclated dimension tab

=Aggr(Max(sales), company)

[omid5ive]

becasue of i need chenge the location of this field i should use it in dim

[tresB]

In the dimension try exp like:          =Aggr(max(sales), company)

[omid5ive]

thanks a lot

[Chanty4u]

welcome:)