Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
aggr(Max(sales), company) as calculated dimension
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
try below then
add in caluclated dimension tab
=Aggr(Max(sales), company)
becasue of i need chenge the location of this field i should use it in dim
In the dimension try exp like: =Aggr(max(sales), company)
thanks a lot
welcome:)