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

[Chanty4u]

wat abt c? 

[giakoum]

not clear what you want to achieve

why is a 2 and not 3 (the sum)?

why is c missing?

Please elaborate

[vinieme12]

Can you provide a sample that replicates your scenario, you've said you want to have "Sale" in dimension but your output table doesn't show how?

Can you create a sample in Excel with data and desired output

[Chanty4u]

may b  this?

[omid5ive]

because the maximum number af a is 2 and want to show the maximum number of each company in my pivot

[omid5ive]

i have to use it in dimensio i cant use this in dim

[omid5ive]

sorry i edited it

[giakoum]

Max(sales) then as expression in the pivot table?

[omid5ive]

i need to use it in dimensio not in expression